What is a good alternative to SQL Server for ASP.NET applications?

Question

I've been looking into a lot of database's recently, and am not sure if it's because I'm bored or what, but I want to create a few web applications using database's other than MS SQL Server. Any suggestions that tie into ASP.NET nicely?

Answer 1

I'd recommend VistaDB and MySql.

Answer 2

I'd consider MySQL as the obvious alternative.

However, fundamentally one relational database is pretty much the same as another, more so when accessed through something like ADO.NET. If you're bored with SQL Server then rather than looking for an alternative why not look at trying different data access strategies?

You don't mention whether or not you're using an ORM (object relational mapper) which can make working with databases a lot more enjoyable than using standard ADO.NET, such as:

• NHibernate
• Entity Framework
• Linq to SQL
• Subsonic

IMO, sticking with SQL Server but trying out a few different ORM's would be much more interesting than switching to a different database altogether.

Or how about looking into using a document database, such as RavenDB?

Answer 3

I suggest you take a look at Connectionstrings.com. Most databases there have a .NET provider available.