tag:blogger.com,1999:blog-5238131531249720750.comments2024-01-22T04:58:27.847+01:00Everything SQL Server CompactErikEJhttp://www.blogger.com/profile/12641272161018114573noreply@blogger.comBlogger1585125tag:blogger.com,1999:blog-5238131531249720750.post-52947661857264412302023-03-12T10:06:47.543+01:002023-03-12T10:06:47.543+01:00@pandabet For performance reasons@pandabet For performance reasonsErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-53401413456178339152023-03-09T00:12:16.326+01:002023-03-09T00:12:16.326+01:00Why does the .sql file gets split into multiple 9M...Why does the .sql file gets split into multiple 9MB files with suffix '_0000'?pandabethttps://www.blogger.com/profile/01806184654745207807noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-68805942898198701882018-05-20T22:15:56.730+02:002018-05-20T22:15:56.730+02:00Thank you Erik for your effort with this !
Regard...Thank you Erik for your effort with this !<br /><br />Regards<br /><br />Tobias JAnonymoushttps://www.blogger.com/profile/13933084720266398848noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-63384206875557792302018-04-20T19:28:32.822+02:002018-04-20T19:28:32.822+02:00@UK: Updated!@UK: Updated!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-15101042095172325392018-04-17T08:59:13.080+02:002018-04-17T08:59:13.080+02:00You could adjust your CodePlex links to point to G...You could adjust your CodePlex links to point to GitHub.UKhttps://www.blogger.com/profile/15586421252144587526noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-20071945497492812072018-04-04T18:25:04.513+02:002018-04-04T18:25:04.513+02:00Ali: What have you tried - and what is not working...Ali: What have you tried - and what is not working? Suggest you ask on Stackoverflow or similar...ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-75123077297260245112018-04-04T08:38:51.171+02:002018-04-04T08:38:51.171+02:00I build my wpf application with access database no...I build my wpf application with access database now I want to deploy it.<br />Please help me to deploy this application.UmarFarooqhttps://www.blogger.com/profile/12889624380704164139noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-38798498678404801312018-04-03T17:47:01.413+02:002018-04-03T17:47:01.413+02:00@Mike: Link updated@Mike: Link updatedErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-59306973016724383132018-04-03T14:28:33.166+02:002018-04-03T14:28:33.166+02:00Hi.
Where download the completed solution?
link in...Hi.<br />Where download the completed solution?<br />link in post dont workMikehttps://www.blogger.com/profile/14278266999979567593noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-40576887359951905862018-04-02T08:20:18.711+02:002018-04-02T08:20:18.711+02:00@rekojem: No, I do not know any other tools - rest...@rekojem: No, I do not know any other tools - restore a backup!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-86621561752161549002018-04-01T19:33:50.303+02:002018-04-01T19:33:50.303+02:00Do you know of any repair tools for sqlce. I have ...Do you know of any repair tools for sqlce. I have a sdf file that will not open and gives the error message The database file is corrupted, possibly due to a file system issue. Ive tried your sqlcecmd40 repairdatabase with no joy aswell as other editors.rekojemhttps://www.blogger.com/profile/15284042836379025660noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-45138733843404928852018-03-31T13:19:32.084+02:002018-03-31T13:19:32.084+02:00Unknown: see my list of tips here for VS 2017: htt...Unknown: see my list of tips here for VS 2017: https://github.com/ErikEJ/SqlCeToolbox/wiki/EF6-workflow-with-SQLite-DDEX-provider ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-48036073727574091722018-03-31T12:46:07.905+02:002018-03-31T12:46:07.905+02:00Cannot get this work on VS 2017? Different produce...Cannot get this work on VS 2017? Different producedure?Anonymoushttps://www.blogger.com/profile/15980488601429439519noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-89497029700136924602018-03-07T16:45:37.791+01:002018-03-07T16:45:37.791+01:00@sai: pls post an issue with more information on t...@sai: pls post an issue with more information on the GitHub repository, then we can work together to solve the issueErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-8676597350670406002018-03-07T15:44:23.751+01:002018-03-07T15:44:23.751+01:00Hi Erik, This tool is great. Off late I started to...Hi Erik, This tool is great. Off late I started to use a bit datatype and do not see any error while creating the table. I see errors while using Select top 100 menu or even creating the database diagram. I am on the latest version 4.7.534.0. Not sure if you ever come across this type. I can write a select statement and it works fine.<br />Can you please let me know if I missing something.<br />Thanks SaiAnonymoushttps://www.blogger.com/profile/08282175223741930555noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-24650725390639022312018-03-02T22:55:53.784+01:002018-03-02T22:55:53.784+01:00The way to fix this with SQL Server 2008 and EF Co...The way to fix this with SQL Server 2008 and EF Core is noted at https://github.com/aspnet/EntityFrameworkCore/issues/4616#issuecomment-221331425ferventcoderhttps://www.blogger.com/profile/08907108080259292428noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-62408453882576541372018-03-01T17:29:04.965+01:002018-03-01T17:29:04.965+01:00@Pedro: SQL Express@Pedro: SQL ExpressErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-87087233324782170962018-02-28T23:53:27.755+01:002018-02-28T23:53:27.755+01:00Hi. I've been working with Visual Studio 2015 ...Hi. I've been working with Visual Studio 2015 and Sql Server Express, now I'm doing my executable with database included but with the mdf, to install it on another machine you need sql server express or just slqlocaldb?Anonymoushttps://www.blogger.com/profile/09674262283449116798noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-83923653938355693702018-02-27T07:25:08.226+01:002018-02-27T07:25:08.226+01:00@Unsure : I think it would still prefer SQL Expres...@Unsure : I think it would still prefer SQL Express, but keep in mind it has a max database size of 10 GBErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-59434116347941710842018-02-22T20:17:47.222+01:002018-02-22T20:17:47.222+01:00hello, I'm not a developer by any means, but I...hello, I'm not a developer by any means, but I can tinker till something finally works! I'm actually a day trader who likes to write my own custom scripts (in C#, .Net 4.5 based) for my trading platform. Unfortunately, one of the things the platform is not good at is the way it loads historical tick by tick data (admittedly, this does ramp up the amount of data noticeably). I am considering attempting to put together something to save the data locally myself using a local/client side database, to hopefully speed things up a bit. In a situation like this one, where the database itself can become ever expanding, while there is no need for an actual server, which version of SQL would you recommend?Unsurehttps://www.blogger.com/profile/15879265576715120168noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-85718211547857295522017-12-05T20:47:17.984+01:002017-12-05T20:47:17.984+01:00Rahmat: I would not recommend using SQL lite on a ...Rahmat: I would not recommend using SQL lite on a web site, use SQL Server Express instead.ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-71326443028479170402017-12-05T18:30:47.731+01:002017-12-05T18:30:47.731+01:00Sir!
These is a problem for me. I want to attach ...Sir!<br /> These is a problem for me. I want to attach my ASP.NET MVC 5 application with SQLITE. But I can't find any solution for me. Now, I am using old one SQL Compact which is going in a good way and also supporting code first and all other entity framework features. But I want to attach SQLite because Microsoft is not going to support Compact more. Can you have any solution for ASP.NET MVC 5. Also, I have not find any example on internet to solve my problem (some examples are there which are for Core and some did not provide Entity Framework support).<br /><br />Also i want to know that, Is SQL Compact is faster or SQL SERVER Express is faster.<br />Thanks in advance<br /><br />Best Regards,Anonymoushttps://www.blogger.com/profile/03804629301196799627noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-43894126438694924752017-11-30T17:59:36.476+01:002017-11-30T17:59:36.476+01:00Thanks for fixing this. I've updated to 6.2.0...Thanks for fixing this. I've updated to 6.2.0.1 and the problem is resolvedAnonymoushttps://www.blogger.com/profile/07577375388660914697noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-72282901912419020082017-11-30T13:58:15.713+01:002017-11-30T13:58:15.713+01:00John: This was a bug, and is fixed in the latest v...John: This was a bug, and is fixed in the latest version of the package: 6.2.0.1 - thanks for reporting this!ErikEJhttps://www.blogger.com/profile/12641272161018114573noreply@blogger.comtag:blogger.com,1999:blog-5238131531249720750.post-73732369891740063082017-11-29T19:42:55.925+01:002017-11-29T19:42:55.925+01:00After installing the EntityFramework.SqlServerComp...After installing the EntityFramework.SqlServerCompact.PrivateDeployment nuget package I get this error when trying to build:<br /><br />The task factory "CodeTaskFactory" could not be loaded from the assembly "C:\Program Files (x86)\MSBuild\14.0\bin\Microsoft.Build.Tasks.v14.0.dll". Could not load file or assembly 'file:///C:\Program Files (x86)\MSBuild\14.0\bin\Microsoft.Build.Tasks.v14.0.dll' or one of its dependencies. The system cannot find the file specified.<br /><br />I am running VS 2015 Community on Win10 x64. To reproduce: I created a new .NET 4.0 Console Application. I set the target output to x86 instead of Any CPU. Then I added the PrivateDeployment nuget package. Then I try to build the project and the error occurs.<br />Anonymoushttps://www.blogger.com/profile/07577375388660914697noreply@blogger.com