Will there be ability to create LINQ to SQL classes for SQL Server Compact Edition?

Question

Subj.

---

There is no knowledge that is not power.

Answer 1

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

Answer 2

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.

Answer 3

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.

Answer 4

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.

Answer 5

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.

Answer 6

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.