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: stackoverflow.com/questions/1121917/… — Dennis Traub
– Dennis Traub, Commented Jun 21, 2012 at 18:55

Martin Costello · Accepted Answer · 2019-01-15 11:10:37Z

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, 2019 at 11:10

answered Sep 23, 2014 at 19:26

Martin Costello

11.1k5 gold badges67 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Rob Von Nesselrode Over a year ago

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...

Gusdor Over a year ago

@RobVonNesselrode Microsoft disagree - "Express edition includes the SQL Server database engine only. Best suited to accept remote connections or administer remotely." msdn.microsoft.com/en-us/sqlserver2014express.aspx

czuroski · Accepted Answer · 2012-06-21 18:54:29Z

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, 2012 at 18:54

czuroski

4,35210 gold badges53 silver badges87 bronze badges

Comments

cristoph · Accepted Answer · 2013-11-02 08:37:22Z

1

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

answered Nov 2, 2013 at 8:37

cristoph

111 bronze badge

Comments

JBrooks · Accepted Answer · 2012-06-21 19:03:34Z

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, 2012 at 19:03

JBrooks

10k2 gold badges31 silver badges32 bronze badges

Collectives™ on Stack Overflow

Embedding a SQL localdb database in C#.Net

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related