SQL Server Compact/SQLite Toolbox add-in for Visual Studio. This add-in adds several features to help your embedded database development efforts: Scripting of tables and data, import from SQL Server and CSV files and much, much more.
Invaluable tool for SQL Server Compact databases. The editor has now more capabilities which is important. Welcome fix for Save button which now does not open Save File dialog! SQL Server Compact Toolbox is just "must have"! Thanks, Erik! :)
I am just getting started in the world of SQL CE development (long story) but it's nice to see great tools like this exist and have the backing of a great technologist like the author. I actually reached out to him about some Windows Mobile questions and he was happy to answer those. Reminds me of the days when the internet was great, the PreMIFT days. (that's Pre-MyspaceInstagramFaceBookTwitter)
But I digress - an absolute must have for any jumping into SQL server compact and SQLite. Thanks for the support and the tools.
Excellent tool for managing SDF / Compact database files. I loaded an older VS2010 project in the newest VS2015 Community edition without any hassles and have even greater and easier control now than I had before. This will be bookmarked with me for a long time. CE is still an excellent option for standalone and portable applications.
Hi, I installed the tool, but cannot expand the database to see the tables, etc.
I'm using VS 2015 Community and created a database in toolbox and after created tables with code first. The database is there, but I cannot expand it and see the tables of the database.
You were right! I've created the DB through the toolbox and when the solution was built it created other DB in Debug folder, but until now I didn't know that. Now I pointed the toolbox to the correct .sdf file and all is OK.
Thanks very much for your hint!!!
I tried creating a project to test your tool. First, when I display the about box, I notice a bunch of 'no' (see http://i58.tinypic.com/2dv5p4k.jpg). I've already pressed 'Register DDEX Providers' button. Second, when I try to add a new datasource in my project to access a sqlite db file, your tool doesn't show up in the 'Choose provider' window. How to fix that ?
trying to get rid of my problem, I get an error, this time from YOUR tool: I chose Script Database from the menu and then Script Database schema. See http://i59.tinypic.com/2lsxgxs.jpg for the error. The db is a valid one though, it's been created by a video game and can be opened with any sqlite browser tool...
Hi, I was using C# 2010 with SQL Compact on an old laptop and recently bought a new laptop with WIndows 8 and installed Visual Studio 2015. The database program I developed on the old laptop doesn't run under VS 2015 since I don't have SQL Compact on it.
Is there some easy to find and understand how to get SQL CE on 2015? I seem to be in a tailspin trying to figure it out.
Also, this toolbox is a VS extension and can someone point me in the right direction to install this?
Thanks Ron R
To get SQL CE Installed, just install the required runtime as described here: https://sqlcetoolbox.codeplex.com/wikipage?title=Known%20Issues&referringTitle=Documentation - and then install VS 2015 Community (not Express), and then you can simply install the Toolbox from the "Tools, Extensions and Updates" menu
Anytime I want to add a LINQ to SQL for my SQL compact 3.5, I get this error message:
SQL Server Compact - Couldn't find SqlMetal in the expected location: bin\NETFX 4.0 Tools\sqlmetal.exe;
Can you help me?
Thank you in advance
I have found the location but SqlMetal.exe wasn't there at all:
C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 (The tool points to that file path location.)
1 - I uninstalled the extension and reinstalled it thinking that all the default files will be added; but no luck.
However I found other versions where the SqlMetal.exe already exists
C:\Program Files (x86)\Microsoft SDKs\Windows\v8.1A\bin\NETFX 4.5.1 Tools
C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.6 Tools
2 - How can I change the path so SQL Server Compact/SQLite Toolbox will point to one of the versions where the SqlMetal.exe already exists ?
Apologies if this has been answered elsewhere, but I wasn't able to find out after doing some web searching. I'm trying to insert into a .sdf database from an external CSV file. When I try the BULK INSERT command, it appears to not be supported.
SQL Server Compact gives me:
Error Code: 80040E14
Message : There was an error parsing the query. [ Token line number = 1,Token line offset = 1,Token in error = BULK ]
Minor Err.: 25501
Source : SQL Server Compact ADO.NET Data Provider
Num. Par. : 1
Num. Par. : 1
Err. Par. : BULK
What's the recommended way to do a bulk insert? I'm runnign version 4.3.0 on VS2015 Thanks!
Installed SQL Server Compact/SQLite Toolbox but in my version of VS, the option SQL Server Compact/SQLite Toolbox in the menu Tools shows that SQLCE 4.0 & 3.5 is missing. My question is why? In menu Tools\Extension and Updates it shows that version 4.2 is installed.
Some more information in order to understand my problem is when I right click "Data Connections" it is not possible to add SQL Compact 3.5.... as well as 4.0 option. Only possibility is to Add SQLite Connection...
Many thanks in advance for your reply.
I have a project with an entity framework model first pattern. I will generate a database from this model, but first it must be a sql server compact (sdf) database. For that I installed the sql server compact/sqlite toolbox. The dialog to choose the datasource appears, but if I press next, than the dialog will be closed and I don't know why. I think before updating to EF 6 it worked with EF 5. Does anybody have a solution? Thanks Andreas
Hi Erik. Sorry but I need a solution for that. I'm hanging with my project. Here is the link to a demo sample.
In this small sample I have the effect I described. Just open the edmx file and try to generate the database from model based on an existing sdf file.
I've got a table (using compact 4.0 connection) with 2 columns (id and name)
Id is a uniqueidentifier and name is nvarchar(25)
the Id column is not filling in automatically though as I believe it should be and result in me getting an error when i try to enter new rows.
Thanks for reply ErikEj
To be honest i'm not a big fan of signing up for various site for 1 app. which is why i posted here since this is where I got the extension at.
As for my guid problem. I've been using CE tables in the past that did autofil Guid's. In fact I can connect to a previous existing CE database that was created using VS2012 and then add rows to it with your extension with no problem and it auto fills not problem. But if I Create any new tables (which are successful) and then go to add new rows that is when the autofill doesn't happen. Also, I am now using 2013 community.
urg.... I hit the other site once I find it again. but honestly trully agittated by it..
What more information will you need. You were asking the create table script, but as I said in the previous post, creating the table is not the issue.