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.
I just tried Export SQL Server to SQLite and get an error. -- Error Code = 1 Message = SQL Logic Error or missing Database near "'-'" = Syntax error Result = Error -- Looks like there was an error export Field Default Value.
Would it be possible to add a Close connection option to the pop-up menu of a database? I have to restart VS to be able to delete the DB I previously opened by SQL Server SQLite Toolbox. Otherwise it's a great tool!
Thanks so much for your great tool! It is really help me to write my first SQL program in C#. Also, thanks so much for your great documentations/clips and all of your comments in here and in stackoverflow.com .You are the best!
I wish you all success and happiness in your life and business. (5 stars is not enough for your helps!) Best Regards.
Really helpful tool here. It saved me a bunch of time having to take a bunch of screenshots of a SQL CE 3.5 database from VS 2008. I know, not a programming task but still saved me time, and the script it generated would come in handy if I really did need to move to SQL Server Express.
Hi, Erik! Thanks for new version! But I got bad news.
When the project first launched, trying to activate Toolbox makes active "Properties" window, so that I have to activate Toolbox again. It was also in early versions.
I have installed the Sqlite Toolbox, successfully connected to an existing sqlite database, and added DataAccess.cs to my project. However, the table and column attributes are not recognized:
What is the namespace for attributes in the DataAccess.cs?
What references are needed?
Hi Gary, I beleive there is a link to this blog post at the top of the DataAccess.cd file: See the blog post here for help on using the generated code: http://erikej.blogspot.dk/2014/10/database-first-with-sqlite-in-universal.html
Erik - I am having the same problem as Gary (though with a database I created using the Toolbox), plus these additional problems:
-- The generated DataAccess code had "using SQLite" instead of "using System.Data.SQLite", which made the SQLiteConnection class unrecognizable.
-- After fixing the using, SQLiteConnection was ok, but the CreateTable methods were not recognized. There are several CreateXxx methods in the SQLiteConection class, just not CreateTable.
I followed the blog you suggested, including installing the 2 additional Windows Phone and Windows RT extensions, all using the VS Extensions Manager. The problems are still there.
I can see how the Toolbox will be a big help once I'm past the startup challenges. Thanks for your help. Steve
Cincy Steve: As noted above, the generated code is for use with the sqlite-net class code, not with System.Data.Sqlite - please read the blogpost linked above. The same link should be at the top of the generated code.
I have a database that uses DateTimeFormat=Ticks in the connection string. When a DateTimes is written to the database, the value of the Ticks property is written. When I use your tool to query the database, I get an error from DateTime.ParseExact with a very long stack trace.
Can you fix your tool so it checks that property in the connection & interprets the value properly? There's also a property in the connection that tells you what value to use for the DateTimeKind property of the DateTime struct.
Hi Tony, I have made some fixes for that recently, can you describe the issue in more detal here, and tell me the exact extension version you use (from the about dialog in the add-in): https://github.com/ErikEJ/SqlCeToolbox/issues/new
after making the connection , I'll create the data source , and give an error that is not supported, it can be. It is to do a tutorial on how to connect and preecher data grid .
thank you for tool
The Data Source support in my DDEX provider is limited to saving connections on server explorer for use with the EF Tools. Not for creating DataSets, which I do not recommend for using with SQL CE anyway. If you want a quick data access layer, just use the LINQ to SQL code generation
Like using your tool, but I private install SQL CE with my app. Any thoughts on how to get your tool to work with private install? Also, I find this error occasionally https://support.microsoft.com/en-us/kb/974247 Any thoughs?
Can SQL Server Compact/SQLite Toolbox add-in help me use SQL statements to do operations on SQLite on UWP/Windows 10 environment (desktop, mobile etc.)?
I am not able to find that detail in the description of the package...
I have used your plug in in Visual Studio 2015 Community and it works fine. I have manged to script out LocalDB Schema and Data and created .sql file. Only DB tables were scripted out. How to script out Stored Procedures from the same LocalDB. All this will be uploaded to the SqlServer 2012 Developer.Thank you for your time.
Great job! Thanks for this tool. It is just amazing. Quick question. Is there an API (DLL) so that the Script generation of SQL Server Database Schema and Data to SQLite can be called inside a C# code?
Glad you like it, feel free to post a review here! You can use my API, yes: http://erikej.blogspot.dk/2013/03/sql-server-compact-code-snippet-of-week.html (Just replace DB4Repository with ServerRepository)
I have another issue when calling the assembly:
The error meaasage is the following:
The type or namespace name 'ErikEJ' could not be found (are you missing a using directive or an assembly reference?).
Any idea about what's missing? Thanks in advance for your reply knowing your busy schedule.
Is this Toolbox compatible with VS2015 Community?
I tried to install it with VS2013 Express and get informed that it´s not compatible with that version. So, i installed VS2015 Community and tried to install the toolbox, but nothing happens, no errors, no messages...