|
7/16/2010 12:54:12 AM
|
neaflo
Posts 12
|
Hi,
If I manually remove the schema from the table name in Linq2Sql diagram (Table properties/Source field) the add-in fails to see the latest table changes. It behaves like there has been no change. I'd expect this to work as the database user I use to connect to SQL Server owns the schema, so the database objects under this schema don't necessarily need to be prefixed by a schema name. If I prefix again the tables with the schema name the add-in reflects the changes correctly in the diagram.
I guess the add-in parses the table properties/source field and it always expects the schema to retrieve the metadata. Could the add-in assume the default schema of the connecting user for tables whose names are not prefixed by a schema. Is this something that can be done in next releases, or I'm missing something in settings? I'd very much appreciate a confirmation of whether this can be included in the next release(s).
Thanks,
Florin Neamtu
|
|
7/16/2010 3:47:32 AM
|
Kristofer
Posts 256
|
Hi Florin,
Schema-less mode is planned for ver 1.92.
Currently the update function won't be able to identify tables without schema since it uses both schema and table name to match to entities in the model.
Best regards,
Kristofer
|
|
7/16/2010 3:35:40 PM
|
neaflo
Posts 12
|
That's really good news Khristofer! Thanks a lot.
|
|
8/10/2010 3:28:01 AM
|
Kristofer
Posts 256
|
"Schemaless mode" is available now (as of ver 1.92).
To enable it, check the "Schemaless Mode" checkbox in the Options box in the update/compare options dialog. If the Options box is not visible, click on the "advanced" button to make it appear.
When switching to schemaless mode, schema prefixes for tables, views, procedures and functions will be removed from the dbml (and generated classes), and instead moved to a separate file ([dbmlfile].schemainfo). The add-in will use the information from the .schemaInfo file when running the compare/update commands.
Note that this assumes that there are no duplicate table names in different schemas.
|
|
8/10/2010 11:47:10 AM
|
neaflo
Posts 12
|
Really great and timely! Thanks a lot.
|
|
pages:
1 |
|---|