tag:blogger.com,1999:blog-5238131531249720750.post8654630551697132149..comments2024-03-19T13:28:26.291+01:00Comments on Everything SQL Server Compact: Entity Framework 6 & SQL Server Compact 4.0 (4) - Restoring full EF Tools support in Visual Studio 2013ErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger23125tag:blogger.com,1999:blog-5238131531249720750.post-60301083948869291102014-10-30T13:31:09.926+01:002014-10-30T13:31:09.926+01:00This comment has been removed by the author.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-55606406658687886802014-10-30T13:31:08.871+01:002014-10-30T13:31:08.871+01:00Bradley: Foolow the error message and look at the ...Bradley: Foolow the error message and look at the Inner exception...ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-59885745373584096662014-10-30T12:24:53.550+01:002014-10-30T12:24:53.550+01:00Good Day David.
I have been trying to develop a w...Good Day David.<br /><br />I have been trying to develop a windows form application using EF and SQL Compact. I have tried almost all compact editions but on db.savechages it fails with error :An error occurred while updating the entries. See the inner exception for details.<br /><br />I have searched and tried different methods stated by many developers but still i cant save data. I need your help please. <br />sample code below. <br /><br />using (var context = new AWModel.Model1Container())<br /> {<br /> var peoples = new Person {Name = "james", SurName = "john" };<br /> context.People.AddObject(peoples);<br /> context.SaveChanges();<br /><br /> var item = context.People.ToList();<br /><br /> }<br /> }<br /> }<br /><br /><br />thanksBradleyhttps://www.blogger.com/profile/06477993828515078549noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-3993090071450469332014-02-28T00:35:22.461+01:002014-02-28T00:35:22.461+01:00Hi Erik,
Thanks for the tip. That worked!
I was ...Hi Erik,<br /><br />Thanks for the tip. That worked!<br /><br />I was able to use your CodeGen feature to create an edmx model, however when I attempt to create one using the VS Wizard I keep getting the error message "...An Entity Framework database provider compatible with this version could not be found for your data connection..." <br /><br />Oh well.<br /><br />Coder DudeCoder Dudehttps://www.blogger.com/profile/04421677880729872035noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-4028685312234482332014-02-27T09:00:23.234+01:002014-02-27T09:00:23.234+01:00Dude: Make sure you open the Toolbox and then rest...Dude: Make sure you open the Toolbox and then restart VS.. Let me know if that does not work for you. You can also use my Code Generation feature from the Toolbox context menu without the DDEX provider.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-87620947773182417502014-02-27T07:35:55.868+01:002014-02-27T07:35:55.868+01:00Hi Erik,
Great tool!
I have just installed your ...Hi Erik,<br /><br />Great tool!<br /><br />I have just installed your 3.7.1 toolbox onto my VS 2013 Pro dev machine but when I check the About box all I see is a "No" against "SQL Server Compact 4.0 Simple DDEX Provider" instead of "Yes". As a result, I can't create an EF 6 model against my CE database. Any ideas?<br /><br />Take care,<br /><br />Coder DudeCoder Dudehttps://www.blogger.com/profile/04421677880729872035noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-55068200934879846372014-02-26T12:48:31.039+01:002014-02-26T12:48:31.039+01:00Jeff: C# - sorry - contact me by email should you ...Jeff: C# - sorry - contact me by email should you decide to proceed anywayErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-54522537450794570702014-02-26T12:45:27.799+01:002014-02-26T12:45:27.799+01:00Hi Erik
Aha. I was hoping to get involved in an o...Hi Erik<br /><br />Aha. I was hoping to get involved in an open source project one of these days. This might be it [not that I really have time ;-)].<br /><br />VB, I hope...?<br /><br />Thanks,<br />Jeff Bowman<br />Fairbanks, Alaska<br />Jeffhttps://www.blogger.com/profile/06491194725178662674noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-21852339433696829072014-02-26T10:47:21.739+01:002014-02-26T10:47:21.739+01:00Jeff: Are you using 4.0 or 3.5? It was very painfu...Jeff: Are you using 4.0 or 3.5? It was very painful simply to get the basic DDEX provider up and running, in particular for 3.5, as it does not have DbConnectionStringBuilder and GetSchema. So adding column enumeration and drag/drop I could not manage. But as this project is open source, I would be happy to have your contribution, and can alos provide pointers on what to do (I know that and con provide sample code, just could not get it to work)ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-36323551682651056512014-02-26T09:25:30.688+01:002014-02-26T09:25:30.688+01:00Hi Erik
Nice. Next DDEX request... ;-)
Any chanc...Hi Erik<br /><br />Nice. Next DDEX request... ;-)<br /><br />Any chance of drag/drop onto a DBML surface?<br /><br />Thanks,<br />Jeff Bowman<br />Fairbanks, Alaska<br />Jeffhttps://www.blogger.com/profile/06491194725178662674noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-15059502983460785662014-02-26T09:02:54.770+01:002014-02-26T09:02:54.770+01:00Jeff: Yes, great suggestion, if the DDEX install c...Jeff: Yes, great suggestion, if the DDEX install can proceed (all requirements are fulfilled) and completes, I will show a message in the Toolbox toolbar to restart VS https://sqlcetoolbox.codeplex.com/workitem/11598 ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-75313210916946435932014-02-26T08:57:44.310+01:002014-02-26T08:57:44.310+01:00Hi Erik
No, I hadn't restarted VS (RTFM). Tha...Hi Erik<br /><br />No, I hadn't restarted VS (RTFM). That fixed it.<br /><br />The instruction to do so wasn't easy to find, though. Maybe you could show a message after installation, if that's possible?<br /><br />Keep up the good work.<br /><br />Thanks,<br />Jeff Bowman<br />Fairbanks, Alaska<br />Jeffhttps://www.blogger.com/profile/06491194725178662674noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-55076250632415007082014-02-17T22:45:44.269+01:002014-02-17T22:45:44.269+01:00Niv: The 3.5 DbProvider must Be enabled, IF not, r...Niv: The 3.5 DbProvider must Be enabled, IF not, reinstall 3.5. You can check the Toolbox About dialog.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-4152162584405514392014-02-17T22:07:24.661+01:002014-02-17T22:07:24.661+01:00Hi Again,
10x 4 the quick resonse.
sync 2.1 sdk is...Hi Again,<br />10x 4 the quick resonse.<br />sync 2.1 sdk is installed and 3.5 is installed still sync menu item is grey<br /><br />am i missing something?Anonymoushttps://www.blogger.com/profile/12430354411000189830noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-27102054073221672342014-02-17T21:48:10.166+01:002014-02-17T21:48:10.166+01:00Niv: You need the 2,1 Sync framework and SqlCe 3,5...Niv: You need the 2,1 Sync framework and SqlCe 3,5 installed to use the sync tools. See junet blog for how to use 4,0 with a binding redirectErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-29161450865198856072014-02-17T21:40:53.864+01:002014-02-17T21:40:53.864+01:00Hi Erik,
first big 10x for this toolbox.
could yo...Hi Erik,<br />first big 10x for this toolbox.<br /><br />could you please advice me on how to use the "sync framework tools" seems to be disabled.<br /><br />all i need is to sync my local sql ce 4.0 db with an sql server instance only upload direction.<br /><br />any help will do.Anonymoushttps://www.blogger.com/profile/12430354411000189830noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-71839640743739299052014-02-15T08:24:19.711+01:002014-02-15T08:24:19.711+01:00Jeff: deleted your comment by mistake. Have you op...Jeff: deleted your comment by mistake. Have you opened the Toolbox after install, then restarted VS?ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-22022753672687287302014-02-10T16:45:55.496+01:002014-02-10T16:45:55.496+01:00Kaanmookob: I would not recommend storing large mp...Kaanmookob: I would not recommend storing large mp3 files in your SQL CE db, store just the names and store the files in the file systemErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-64162661035212464352014-02-10T12:54:49.369+01:002014-02-10T12:54:49.369+01:00hi ErikEJ, I'm following your blog. I'm ne...hi ErikEJ, I'm following your blog. I'm new windows phone 8 dev. I want create a application that have many audio files and I need to add my audio files (.mp3) to sqlce table. I'm not sure that sqlce support for this or not ? Could you please give me some information or How can I do this ? Please help Kanamookobhttps://www.blogger.com/profile/08344386306000552228noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-77586161504565048362014-02-04T09:07:53.567+01:002014-02-04T09:07:53.567+01:00Thanks for the kind words, David. re a: Expect no ...Thanks for the kind words, David. re a: Expect no future versions of SQL Server Compact, still waiting for an official statement from Microsoft. The official product support lifecycle is here: http://support.microsoft.com/lifecycle/search/default.aspx?sort=PN&alpha=SQL+Server+Compact&Filter=FilterNOErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-9089097809173546082014-02-03T22:12:15.156+01:002014-02-03T22:12:15.156+01:00a) All I meant was ... does leaving out the featur...a) All I meant was ... does leaving out the feature in the newer VS mean SQL Server Compact is being deprecated or neglected, by Microsoft, in a way that bodes ill for depending on it in the future?<br /><br />b) Ok, it wasn't easy! But it was <i>possible</i>! And if it was possible for you ... it was possible for them ... I didn't mean to disparage your hard work! Not when I'm heavily dependent on SQL Server Compact Toolbox!<br /><br />-- DavidDavidhttps://www.blogger.com/profile/09358968282816697343noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-21463632090272762752014-02-03T21:26:16.876+01:002014-02-03T21:26:16.876+01:00David: Not exactly sure what you are asking, but I...David: Not exactly sure what you are asking, but I suppose it Means that it was hard to use SqlCe with EF in VS2013, and now it is less hard. (And believe me, it was not "easy")ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-6283778554343453992014-02-03T20:00:47.719+01:002014-02-03T20:00:47.719+01:00So, what does it mean for SQL Server Compact Editi...So, what does it mean for SQL Server Compact Edition that this feature was left out of VS2013, if it was apparently easy for you, external to Microsoft, to implement? (If you've answered this elsewhere please just point me to it, thanks!)<br /><br />-- DavidDavidhttps://www.blogger.com/profile/09358968282816697343noreply@blogger.com