Non-unique DB object names
I have multiple schemas within SQL Server database, I noticed that in this case Linqpad generates class names inconsistently.
For example, I have a table called Broker in schema "master" and in schema "stage". Sometimes Linqpad generates class name as Master_Broker, and sometimes just as Broker, this is not a schema permission issue as always the same SQL login is used.
As a result, perfectly working scripts randomly produce compilation error and object names need to be updated. Please can this be fixed, I would expect the non-unique object names always be prefixed with schema names.
Linqpad Premium 5.43.00 anyCPU, native LINQ to SQL driver.
Comments
Can you post a schema (DDL) that reproduces this?