Embedding a SQL localdb database in C#.Net

Question

I want to create an application and for that I need to have a database. By searching Google I came to know that for my purpose SQL localdb will be good as it is light and fast. Kindly tell me the procedure for embedding this database in my program. I want to create a desktop application which can run on any Windows machine.

Here's a good example for SqlCE on Stackoverflow: http://stackoverflow.com/questions/1121917/local-database-i-need-some-examples — Dennis Traub, Jun 21 '12 at 18:55

Martin Costello · Answer 1 · 2019-01-15T11:10:37.247

3

I maintain a C# wrapper to the SQL LocalDB API in GitHub which is also available in NuGet. It will allow you to manage instances of SQL LocalDB in your application.

edited Jan 15 '19 at 11:10

answered Sep 23 '14 at 19:26

Martin Costello

9,672
5
60
72

Simply embedding an instance of the sql express localDb does not require the use of Martin's excellent wrapper assuming you have ways of creating the database and other management tasks in the first place. There is the Microsoft supplied command line tool 'SqlLocalDb.exe' for that and of course VS 2013 itself. However if you want to fully manage the API behind localDb from code, this wrapper is useful. Be aware that localDb is designed as a development tool for futzing around with sql. For production, better to utilise Express or higher. Martin's reply should be the answer... – Rob Von Nesselrode Feb 21 '15 at 02:11
@RobVonNesselrode Microsoft disagree - _"Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely."_ https://msdn.microsoft.com/en-us/sqlserver2014express.aspx – Gusdor Nov 18 '15 at 16:05

score 1 · Answer 2 · answered Jun 21 '12 at 18:54

1

Sql CE may be a good fit. Scott Guthrie posted about implementing this - http://weblogs.asp.net/scottgu/archive/2011/01/11/vs-2010-sp1-and-sql-ce.aspx

answered Jun 21 '12 at 18:54

czuroski

4,316
9
50
86

score 1 · Answer 3 · answered Nov 02 '13 at 08:37

1

you can use Siaqodb,it is a C# written db and it is designed for embedded envs - http://siaqodb.com

answered Nov 02 '13 at 08:37

cristoph

11
1

score 0 · Answer 4 · answered Jun 21 '12 at 19:03

0

I've had success using SQL Express in that way.

The most widely deployed database like you describe is SQLite. I would check that out as well.

SQLite HERE

Using a C# wrapper HERE

Or a C# port of SQLite HERE

answered Jun 21 '12 at 19:03

JBrooks

9,901
2
28
32

Embedding a SQL localdb database in C#.Net

4 Answers4

Linked