Dear Michael,
Found a Bug related to table schema and the way, I think you retrieve and cache SQL Table information.
Let's say you have a table
[directory].[Companies] with a Column [Name] maps to an Object Company with a Property Name
and another table (the schema is different)
[survey].[Companies] with also a Column [Name] maps to an Object SurveyCompany with a Property Name
If you an insert of a new SurveyCompany, you get the error
"The variable name '@name' has already been declared. Variable names must be unique within a query batch or stored procedure."
If the second column [survey].[Companies].[Name] is renamed to [CompanyName], all is fine.
Best
Gilles
Dear Michael,
Found a Bug related to table schema and the way, I think you retrieve and cache SQL Table information.
Let's say you have a table
[directory].[Companies] with a Column [Name] maps to an Object Company with a Property Name
and another table (the schema is different)
[survey].[Companies] with also a Column [Name] maps to an Object SurveyCompany with a Property Name
If you an insert of a new SurveyCompany, you get the error
"The variable name '@name' has already been declared. Variable names must be unique within a query batch or stored procedure."
If the second column [survey].[Companies].[Name] is renamed to [CompanyName], all is fine.
Best
Gilles