SQL Server Developer Center >
SQL Server Forums
>
SQL Server Compact
>
Will there be ability to create LINQ to SQL classes for SQL Server Compact Edition?
Will there be ability to create LINQ to SQL classes for SQL Server Compact Edition?
- Subj.
There is no knowledge that is not power.- Moved byCharles SterlingMSFTMonday, October 26, 2009 12:18 AMNot VSTS (From:Visual Studio Team System 2010 Beta2)
Answers
- Hi,
Find how to use L2S against sqlce at
http://blogs.msdn.com/sqlservercompact/archive/2007/08/21/linq-with-sql-server-compact-a-ka-dlinq-over-sql-ce.aspx
--Tarun Ramsinghani- Proposed As Answer byChunSong Feng -MSFTMSFT, ModeratorMonday, October 26, 2009 6:20 AM
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorFriday, October 30, 2009 2:55 AM
- Hi,
Please read the following two threads:
Error: "The selected object(s) use an unsupported database provider":
http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/87f1e8cc-88ed-4670-9152-6d2bc9bb50d6/
"SQL Server Compact 3.5 SP1 / VS2008 designer: se sqlmetal LINQ to SQL or LINQ to Entities?":
http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/5f7ff092-23e2-4146-8a13-015d25d544db/
ChunSong Feng
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorFriday, October 30, 2009 2:54 AM
All Replies
- Hi,
Find how to use L2S against sqlce at
http://blogs.msdn.com/sqlservercompact/archive/2007/08/21/linq-with-sql-server-compact-a-ka-dlinq-over-sql-ce.aspx
--Tarun Ramsinghani- Proposed As Answer byChunSong Feng -MSFTMSFT, ModeratorMonday, October 26, 2009 6:20 AM
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorFriday, October 30, 2009 2:55 AM
- Hi,
Here is a article about SQL Server Compact 3.5 and LINQ to SQL, see here: http://msdn.microsoft.com/en-us/library/bb546181.aspx
Hope this helps.
ChunSong Feng
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
Sorry for wrong question. I meant following: when I create empty LINQ to SQL class, I can drop table from SQL Server onto surface of OR Designer, but when I drop table from SQL Server CE, then error occurs "The selected object(s) use an unsupported data provider". So, this way of creation LINQ2SQL classed I mean.
There is no knowledge that is not power.- Hi,
Please read the following two threads:
Error: "The selected object(s) use an unsupported database provider":
http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/87f1e8cc-88ed-4670-9152-6d2bc9bb50d6/
"SQL Server Compact 3.5 SP1 / VS2008 designer: se sqlmetal LINQ to SQL or LINQ to Entities?":
http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/5f7ff092-23e2-4146-8a13-015d25d544db/
ChunSong Feng
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
- Marked As Answer byChunSong Feng -MSFTMSFT, ModeratorFriday, October 30, 2009 2:54 AM
- Thanks for links! Now the picture is clear. By the way, here's one more question. I have read a lot about that LINQ to SQL won't be supported and updated and instead of it we should use LINQ to Entities. Does it mean that L2S is gonna die soon?
There is no knowledge that is not power. Thanks for links! Now the picture is clear. By the way, here's one more question. I have read a lot about that LINQ to SQL won't be supported and updated and instead of it we should use LINQ to Entities. Does it mean that L2S is gonna die soon?
There is no knowledge that is not power.
Hi,
This is a interesting question, I think you may post a thread in development forums(ASP.NET/LINQ to SQL etc.), they are more experts with rich development experience.
Welcome to our fourms again!
ChunSong Feng
Microsoft Online Community Support
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.


