tag:blogger.com,1999:blog-5238131531249720750.post352973841076283587..comments2024-03-19T13:28:26.291+01:00Comments on Everything SQL Server Compact: Entity Framework with SQL Server Compact 4.0 and ASP.NET – Dynamic Data, OData, deployment (part two)ErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-5238131531249720750.post-73432041390021541092013-04-22T16:17:40.346+02:002013-04-22T16:17:40.346+02:00To follow up on Linq to SQL, this IS possible with...To follow up on Linq to SQL, this IS possible with SQL CE 4,0 ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-70622110026458619972011-03-14T13:12:06.631+01:002011-03-14T13:12:06.631+01:00This is a permanent situation, yes. Start learning...This is a permanent situation, yes. Start learning Entity Framework!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-44723943288787550702011-03-14T12:06:46.537+01:002011-03-14T12:06:46.537+01:00Is this a permanent or temporary situation I also ...Is this a permanent or temporary situation I also want to use linq-to-sql with ssce 4.0?Anthony Tarlanohttps://www.blogger.com/profile/00089541345794484144noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-80333782241623493322011-01-17T20:17:21.428+01:002011-01-17T20:17:21.428+01:00Joset: Liqn to SQL is not supported with SQL Serve...Joset: Liqn to SQL is not supported with SQL Server Compact 4.0, you must use Entity Framework 4 instead (which now supports many features from LINQ to SQL)ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-83144228193911877752011-01-17T18:37:31.792+01:002011-01-17T18:37:31.792+01:00Hi ErikEJ,
I have been following your blogs on MS...Hi ErikEJ,<br /><br />I have been following your blogs on MS SQL Compact 4.0.<br /><br />Please, I need your expert guide on the newly realeased SQL Compact 4.0. I wanted to generate a .dbml file using SQLMetal.exe for VS2010 desktop app built on .Net framework 4.0 in order to use Linq-to-SQL but it failed with the following error.<br /><br />===================================================<br />C:\>SqlMetal.exe myDatabase.sdf /dbml:myDataContext.dbml<br />Microsoft (R) Database Mapping Generator 2008 version 1.00.30729<br />for Microsoft (R) .NET Framework version 3.5 Copyright (C) Microsoft Corporation. All rights reserved.<br /><br />Error : Incompatible Database Version. If this was a compatible file, run repair. For other cases refer to documentation. [ Db version = 4000000,Requested version = 3505053,File name = \\?myDatabase.sdf ]<br />===================================================<br /><br />Obviously, the SQLMetal.exe tool seems not to be supporting SQL Server Compact 4.0 even after installing Windows SDK version 7.1, which I think contains latest version of SQLMetal tool.<br /><br />Could you guide me on how to overcome this hurdle and easily generate the needed .dbml file from SQL Server Compact 4.0 quickly?<br /><br />Thank you in advance.<br />Joset.Unknownhttps://www.blogger.com/profile/11735515937813014291noreply@blogger.com