CODEWITHSUNDEEP
c#database
Afnan Bashir
Afnan Bashir

Reputation: 7429

Do Access Database require any database engine?

If we develop application that has access database in it dose it needs to have any other thing installed on client machine with dot net frame work?

Is there any other databse easy to use may be small which does not require additional install than dot net framework

Upvotes: 1

Views: 349

Answers (4)

DRapp
DRapp

Reputation: 48149

Another is SQLite... a single .dll drop-in and integrates with .Net via simlar

using System.Data.SQLite; 

using System.Data.OleDB;  

using System.Data.SQL;

using System.Data.ODBC;

each have similar signatures for creating connections, creating SQLCommand objects, Parameterizations, execution, etc... When I was doing testing between different platforms, I found SQLite database and Visual Foxpro database faster than Access. When compared to VistaDB (just simulating populating large dataset of 100k records), it almost choked on me.

Upvotes: 0

Guy Starbuck
Guy Starbuck

Reputation: 21873

Access will work, you won't need to install any separate software, the .NET framework has data providers for Access, you can use the ODBC provider.

The recommended solution from Microsoft for embedded databases, however, is SQL CE -- check it out, you can embed it in your solution and have your app's installer configure it (no separate installation). It also has the benefit of being free.

EDIT: As noted below by @Joe, no license is needed to use Access; however, it is a file-based database, and is not as reliable as SQL CE.

Upvotes: 0

Uwe Keim
Uwe Keim

Reputation: 40736

You could use VistaDB. I am using it successfully in several projects.

It requires only .NET Framework 2.0 or higher and one single DLL that is easily XCOPY deployable without any registration/installation.

The performance is somewhat slower than e.g. Microsoft Access (which requires Jet) but for my purposes it was always good enough.

Another candidate would be Microsoft SQL Server Compact Edition (CE). This is also a database that requires no installation or registration, you just ship some additional DLLs with your application.

Upvotes: 1

dsum
dsum

Reputation: 1493

That depends on what database you are using. If you use MS SQL, you can use the System.Data.SqlClient. If you are using Oracle, you may need to use third party .NET library.

Upvotes: 0

Related Questions