CODEWITHSUNDEEP
c#asp.net.netdatabase
chetan
chetan

Reputation: 51

What database should I use for small dotnet Application?

I am developing a small application with ASP and C# in .NET and I want to have a small local database next to it where I can save and retrieve records by either SQL queries or Linq queries. I don't need anything powerful, just something to use instead of keeping records in .txt files.

So what's your suggestion?

Upvotes: 3

Views: 7934

Answers (8)

Alex Klaus
Alex Klaus

Reputation: 8934

In your case I would consider the following:

  1. XML if you don't with more than a couple hundred records in all tables. And @Ali mentioned already LINQ to XML what will be handy.
  2. VistaDB, because it's 100% managed code and require deployment of just one small assembly for both 32- and 64-bit.
  3. SQL CE, just because it's the most popular one. Of course, it supports LINQ and concurrency.
  4. SQLite as an alternative for SQL CE :)

Don't go with SQL Express unless it's been already provided by your hoster. It increases complexity of distributing/installing of your solution.

Upvotes: 0

kappa
kappa

Reputation: 1569

I'll consider SQLite for this purposes.

If you are more comfortable with MS tools, or for some reason (i.e. your company already has a well formed mdb database file) you can use MS Access too, for local and small applications.

Upvotes: 1

Dave Becker
Dave Becker

Reputation: 1433

No one's mentioned it yet so here it is. mySQL and the .Net mySQL client.

Upvotes: 0

Panda Zhang
Panda Zhang

Reputation: 483

I recommend you to use SQL Server Express, becuase

  1. It is free to use and easy to install
  2. You can easily use either Entity Framework or LINQ TO SQL to manipulate your data
  3. It can easily communicate with your company's DB ( if it is also SQL Server), for example, one day in the future, you may need to test the replication.

Upvotes: 0

Shailesh
Shailesh

Reputation: 1218

Best to use SQL Express edition since it comes for free. Try using .NET entity framework code first for rapid application development.

In any case application is very small consider using SQL express since you can write neat and clean stored procedures and can play with other database objects.

Please refer http://www.microsoft.com/sqlserver/en/us/editions/express.aspx for more details.

Upvotes: 1

Alex
Alex

Reputation: 6149

I would go with either SQLLite or with XML since you are saying very small database.

And with xml you can use Linq to xml

Upvotes: 2

RvdK
RvdK

Reputation: 19790

You can use SQL CE or SQLite.

Upvotes: 1

juergen d
juergen d

Reputation: 204756

Use SQLite

It does not have to be installed and is just a DB File and there are connectors to .Net available.

And you can use LINQ

Upvotes: 4

Related Questions