Skip to content

Bug: Table schema is ignored for the identical table names #456

@sellig

Description

@sellig

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

Metadata

Metadata

Assignees

Labels

bugSomething isn't workingdeployedFeature or bug is deployed at the current releasepriorityTop priority feature or things to dotodoThings to be done in the future

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions