Embedded Database for.net that can escape a network

I was (and also still am) seeking an embedded database to be made use of in a.net (c#) application. The caution: The Application (or at the very least the database) is saved on a Network drive, yet just made use of by 1 customer at once.

Currently, my first suggestion was SQL Server Compact edition. That is actually perfectly integreated, yet it can not escape a network.

Firebird appears to have the very same concern, yet the.net Integration appears to be not actually excellent and also is greatly undocumented.

Blackfish SQL looks intriguing, yet there is no test of the.net Version. Rates is additionally ALRIGHT.

Any kind of various other pointers of something that functions well with.net and also escape a network without the demand of in fact mounting a web server software program?

2019-05-04 21:20:07
Source Share
Answers: 6

There is additionally Valentina. I cam e throughout this item when I was working with some Real Basic task. The RB variation is great.

2019-05-21 20:37:07

You can make use of the firebird embeded, it is simply a dll that you will certainly require to deliver with you app.

Concerning points being undocumented, that is not actually real, the firebird.NET vehicle driver applies the ADO Interfaces, so if you recognize ADO you can collaborate with Firebird, primarily as opposed to SQLConnection you will certainly make use of FBConnection and more, yet my suggestions is to write an information accessibility layer and also make use of simply user interfaces on your code, something similar to this:

using FirebirdSql.Data.FirebirdClient;

public static IDbConnection MyConnection()
    FbConnection cn = new FbConnection("...");
    return cn;

This instance is really straightforward, yet you will certainly not require far more than that.

We make use of firebird for our all application with no troubles, you need to at the very least attempt it out.

2019-05-19 16:01:44

It seems like ADO/Access is excellent for your demands. It's baked right into the MS pile, well skilled, and also multi - customer.

You can programatically create a DB thus :

Dim catalog as New ADOX.Catalog
Catalog.Create("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\server\path\to\db.mdb")

You can after that make use of typical ADO.NET approaches to connect with the database.

2019-05-08 05:08:23

Why not make use of SQL Server 2005 Express edition?

It actually relies on what you suggest by "ingrained" - yet you can rearrange SQLServer2005E with your applications and also the customer never ever needs to recognize it's there.

Embedding SQL Server Express in Applications

Embedding SQL Server Express into Custom Applications

2019-05-08 05:00:12

SQLite involved my mind while reviewing your inquiry, and also I'm fairly certain that it's feasible to accessibility it from a network drive if you maintain on your own to the restraint of 1 customer at once.

SQLite on .NET - Get up and running in 3 minutes

2019-05-08 04:56:03

Check out VistaDB. They have a great item, the web server variation (3.4) remains in Beta and also is really near release.

2019-05-08 04:05:26