I use DD for quite some time, and at times it was that L2S class became inoperable. Once again, it happened today.
Neither the changes in dbml not lead to changes in the designer. I have not found anything better than to create a new L2S class. Is there any other way to solve this problem?
No error codes. However, for example, after adding a new table to a DataClasses.dbml, it does not appear in the DataClasses.designer.cs
As a result, the new table does not appear in the MetaModel.VisibleTables. The same goes for the Columns, columns Names, ConnectionString and any changes in dbml. The impression is that the MSLinqToSQLGenerator stops working
1) Just double click the dbml file and then drag and drop a new table into the file, it will automatically generate a LINQ model.
It was after this action, I noticed that it does not automatically generate a LINQ model, although the date of the DataClasses.designer.cs is changed.
Decker Dong - MSFT
2) If still fails, please delete the dbml file and re-create another new one, then follow step 1.
That's what I doing. But when the dbml file is large, ie displays a large number of tables with multiple connections, re-create another new one is not easy job.
valZ
Member
128 Points
40 Posts
L2S class
Feb 08, 2013 04:35 AM|LINK
Hi all.
I use DD for quite some time, and at times it was that L2S class became inoperable. Once again, it happened today.
Neither the changes in dbml not lead to changes in the designer. I have not found anything better than to create a new L2S class. Is there any other way to solve this problem?
(VS2010, Framework 4.0)
Thanks.
ignatandrei
All-Star
135142 Points
21676 Posts
Moderator
MVP
Re: L2S class
Feb 08, 2013 06:46 AM|LINK
What are the symptoms? Error code? Something ?
valZ
Member
128 Points
40 Posts
Re: L2S class
Feb 08, 2013 07:06 AM|LINK
ignatandrei, thank you for your reply.
No error codes. However, for example, after adding a new table to a DataClasses.dbml, it does not appear in the DataClasses.designer.cs
As a result, the new table does not appear in the MetaModel.VisibleTables. The same goes for the Columns, columns Names, ConnectionString and any changes in dbml. The impression is that the MSLinqToSQLGenerator stops working
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: L2S class
Feb 10, 2013 12:21 AM|LINK
Hi,
You can try either of the ways:
1) Just double click the dbml file and then drag and drop a new table into the file, it will automatically generate a LINQ model.
2) If still fails, please delete the dbml file and re-create another new one, then follow step 1.
valZ
Member
128 Points
40 Posts
Re: L2S class
Feb 11, 2013 05:02 AM|LINK
Thank you, Decker Dong.
It was after this action, I noticed that it does not automatically generate a LINQ model, although the date of the DataClasses.designer.cs is changed.
That's what I doing. But when the dbml file is large, ie displays a large number of tables with multiple connections, re-create another new one is not easy job.
Decker Dong ...
All-Star
118619 Points
18779 Posts
Re: L2S class
Feb 14, 2013 10:34 AM|LINK
Hi,
If you wanna dynamically change the tables' schemas, you can consider using ADO.NET (I mean SqlDataSource instead of LINQ).