Is there a way to create an sqllocaldb instance in C #?

Question

Is there a way in C # to directly instantiate an SQLLOCALDB? We are currently using sqllocaldb.exe, but should be able to do this without using an external executable.

Answer 1

You can use the LocalDB Wrapper SQL library.

It wraps the native APIs provided by SQL LocalDB in the .NET 3.5 assembly.

Now it is also available through NuGet .

Disclaimer: I support this library.

Answer 2

I noticed several projects that wrap their own localdb API. I personally have not tried any of them, but the following may be useful for you.

http://www.nuget.org/packages/LocalDbApi/
http://sqllocaldb.codeplex.com/