LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

SQL Server Compact - Compact yet capable : LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

Mighell's Blog — Tue, 21 Aug 2007 13:09:10 GMT

SQL Server Compact - Compact yet capable : LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

Mighell's Mobile Blog — Tue, 21 Aug 2007 14:15:12 GMT

Nella beta 2 di "Orcas", Linq to Sql supporta anche SQL Compact come Data Base! Ovviamente

SQL Server Compact - Compact yet capable : LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

Mighell's Mobile Blog — Tue, 21 Aug 2007 15:09:51 GMT

Nella beta 2 di "Orcas", Linq to Sql supporta anche SQL Compact come Data Base! Ovviamente

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

Taryon — Fri, 31 Aug 2007 04:00:28 GMT

HI!

I executed the sqlmetal as described in this post. The problem is that when I try to compile the project I obtain a mistake regarding no reference to system.linq.expressions that is in system.core in the normal framework but that is not in the compact.

how do I solve this?

thx in advance!

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

gbhasin76 — Tue, 13 Nov 2007 23:04:19 GMT

Hello,

I used sqlmetal to try to create the .cs file using the command line statement. I copied SQLmetal to the directory that contains the sdf file. Below is the statement that I typed.

sqlmetal IvyCRM.sdf /code: IvyCRM.cs

I get the following error:

error SQM1003: Input file 'IvyCRM.cs' does not exist.

Is there something I am missing?

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

mgoetzke — Tue, 27 Nov 2007 15:32:22 GMT

TransactionScope with Linq on SqlCe does not seem to work even though TransactionScope was promised for RTM for CE. Any idea why ?

see: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2466351&SiteID=1&mode=1

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

SQLCEBLOG — Mon, 31 Dec 2007 10:35:07 GMT

Hey Taryon,

I think your problem is with a particular machine configuration. Please make sure of the following:

1) Chose Add Reference, and add a reference to System.Linq.dll (This is common for any data provider)

2) Start with another fresh project

Thanks,

Laxmi

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

SQLCEBLOG — Mon, 31 Dec 2007 10:35:48 GMT

Hey gbhasin76,

I think the extra space after the switch /code: is causing the issue. Please make sure to not have extra spaces.

Thanks

Laxmi

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

Tristan Smith — Tue, 05 Feb 2008 13:01:23 GMT

With 2008 now RTM, I've created a .NET 3.5 PDA application.

I created a 3.5 SQL CE database, ran sqlmetal against it and added the .dbml file to the project.

I get the same issue as Taryon, the compact framework Linq.Core does not contain the Linq.Expressions namespace, in fact it contains about a 1/10 of the namespaces of the full framework version. LINQ To SQL DataSet is there, LINQ to SQL isn't.

Can you confirm that LINQ To SQL CE didn't make it to RTM?

re: LINQ with SQL Server Compact (a.k.a. DLINQ with SQL CE)

laxminro — Mon, 05 May 2008 17:52:12 GMT

Hi Tristan Smith,

LINQ to SQL CE for .NET Framework has got actually released in Visual Studio 2008 RTM.

LINQ to SQL CE for .NET Compact Framework has not been released in Visual Studio 2008 RTM.

We are sorry about this mismatch and we are working towards making it available in our next version, but at the same time I can not guarrenty it being available in SQL CE v4.0 as priorities change over time.

Thanks,

Laxmi

Using LINQ to SQL with SQL Server Compact Edition

Chris Pietschmann — Sat, 31 Jan 2009 06:29:44 GMT

Using LINQ to SQL with SQL Server Compact Edition