CODEWITHSUNDEEP
c#.netdatabase
Tyler
Tyler

Reputation: 678

Access Database Alternatives

Ok before I explain... I know Access should basically not be used anymore.

My application now uses access for its portability.. its an internal application and makes private/internal database storage a snap.

Problem is, it uses JET 4.0 which is not supported in 64 bit operating systems and is frankly not very well implemented anymore.

I am developing using C# .NET visual studio 2008. I am looking for a way to do this with some other database type that would not require me to install anything else on a users computer. I looked into sqlite but there's no easy way to implement it in visual studio

An Ideas?

Upvotes: 1

Views: 1714

Answers (9)

Adnan
Adnan

Reputation: 26350

Did you try with H2?

The main features of H2 are:

Very fast, open source, JDBC API  
Embedded and server modes; in-memory databases  
Browser based Console application  
Small footprint: around 1 MB jar file size

Check out about implementation:

http://www.google.ba/search?sourceid=chrome&ie=UTF-8&q=C%23+h2+database

Upvotes: 1

CrowderSoup
CrowderSoup

Reputation: 164

How about XML? Easy to use, and it works on any platform. Not the easies to implement if you're unfamiliar with it, but it's pretty rad once you learn how it works.

Upvotes: 0

Hugues Van Landeghem
Hugues Van Landeghem

Reputation: 6808

Firebird can be a very good alternative to Access and have very good dot net driver

Here is a comparison between Firebird Embedded and SQL Server Compact Edition

Upvotes: 0

Ed Power
Ed Power

Reputation: 8531

I recommend System.Data.Sqlite (http://sqlite.phxsoftware.com/), a managed, open-source ADO.Net wrapper around the open-source Sqlite database. No installation required - you just include the single DLL in your solution. It boasts a small footprint, encryption, and good performance.

Upvotes: 4

Madison
Madison

Reputation: 411

SQL CE is a good option as already mentioned. You could also consider xml if the data is not private and you don't have concurrent users (which is very likely if you are using Access). Xpath provides a lot of the features you would normally need from database queries and storage. You also wouldn't need to install anything.

Upvotes: 2

Beth
Beth

Reputation: 9607

This is one reason why people continue to use Access. Of course you want an easy solution that doesn't require any installs on the client side.

We've all assumed so far your users are disconnected from your SQL Server. If they can connect, you're home free. It's less of a problem if you need to support read-only disconnected use, more of a problem if you need to pull updated data from disconnected users.

Can you tell us more about what you need?

Upvotes: 0

STW
STW

Reputation: 46366

Access has a couple of key characteristics: - Single-user - Requires installation

For alternatives this gives you (at least):

  • SQL Compact (doesn't require installation, single-user)
  • SQLite (doesn't require installation, single-user--although multi-user is supported)
  • SQL Express (multi-user, requires install)

Upvotes: 2

Brent Arias
Brent Arias

Reputation: 30165

SQL Server Express edition should come with Visual Studio. It is an option at installation time, IIRC.

Upvotes: 2

Oded
Oded

Reputation: 499002

You can use SQL Server Compact 3.5 (the embedded version of SQL Server 2008).

Upvotes: 9

Related Questions