.Net Best sql server to use

HI, I'm trying to create a simple database for my C# .NET application. It's easy enough to create a db and to run it locally, but I was wondering which is the best free one I should Use? Furthermore, I would also like the application to be easily deployable on mult开发者_JAVA技巧iple PCs (each with their own local db instance). What is the best tool for me to use?

---

SQLite is very popular.

http://www.sqlite.org/

I would also add they have fantastic support across many platforms and uses:

http://www.sqlite.org/whentouse.html

---

Take a look at the latest SQL Server Compact Edition. It's designed to be embedded so you can easily deploy with the right files added to your install / copy setup.

http://www.microsoft.com/downloads/en/details.aspx?FamilyID=0d2357ea-324f-46fd-88fc-7364c80e4fdb&displaylang=en

---

Postgres if you need this to be a serious solution, SQLite if it's a lightweight concern.

For my money, Nhibernate support is the important question.

---

If you're using .Net, why not use SQL Server Express Edition?

---

The Microsoft answer is SQL Server CE (Compact Edition): http://www.microsoft.com/sqlserver/2005/en/us/compact.aspx

There is an isntaller, but it can also be deployed just by including a few DLLs.

---

The obvious answer should be the express edition of SQL Server : http://www.microsoft.com/express/Database/

Personally I just use microsoft access most of the time for simple stuff.

---

Note that may users are suggesting SQL Server Compact Edition. It could be useful to know the difference. CE is much more limited, but easier to deploy. Sounds like CE is the better choice for your application.