Is SQL Server Express a serviceable database for a ASP.NET MVC web application?

Before you start using the Development edition, you need to be aware what it is and what the limitations are of you using it SQLExpress is perfectly fine for using, both for dev and when you release your product. It has the same engine as SQL Standard, but with a couple restrictions in place, such as a max file size of 4GB (and I think it also has a RAM limit, but not sure on that one). You are allowed to use SQL Express as the backend for your website with no extra licencing costs (i.e.

- free). I have worked at one place where they worked out a system of chaining several instances of SQL Express together just to get round the 4GB file limit - but be aware that this may contravene the licence of it SQL Developer is actually SQL Enterprise, but without the install time restriction on OS. You are also not permitted to use SQL Developer in production (i.e.

For your live app). For most purposes whatever you code on SQL Developer can also execute on SQL express, but you have to be careful not to use any of the Enterprise features - licencing Enterprise can be a pricey option So go ahead and use SQL Express, it is a good option P.S. - I am assuming that your database won't be high load - if it is then you would need to consider either Standard or Enterprise.

Before you start using the Development edition, you need to be aware what it is and what the limitations are of you using it. SQLExpress is perfectly fine for using, both for dev and when you release your product. It has the same engine as SQL Standard, but with a couple restrictions in place, such as a max file size of 4GB (and I think it also has a RAM limit, but not sure on that one).

You are allowed to use SQL Express as the backend for your website with no extra licencing costs (i.e. - free). I have worked at one place where they worked out a system of chaining several instances of SQL Express together just to get round the 4GB file limit - but be aware that this may contravene the licence of it.

SQL Developer is actually SQL Enterprise, but without the install time restriction on OS. You are also not permitted to use SQL Developer in production (i.e. For your live app).

For most purposes whatever you code on SQL Developer can also execute on SQL express, but you have to be careful not to use any of the Enterprise features - licencing Enterprise can be a pricey option. So go ahead and use SQL Express, it is a good option. P.S.- I am assuming that your database won't be high load - if it is then you would need to consider either Standard or Enterprise.

Great description of how SQL Express is managed, looks like I'll stick with SQL Express. Now to decide whether to upgrade to 2008. – Alastair Pitts Jan 18 '10 at 10:57.

You can develop an ASP. NET MVC application using any of them. Express edition is ok for basic application unless you have a high load application that requires enterprise features.

If you intent to launch the application live then it depends on the traffic the application will have. Also, as far as I know Developer edition is for developers only and cannot be used in production environment.

Many of the examples on MVC I have seen use a local . Mdf (SQL database) as their backend. This is only because it's very easy to provide physical .

Mdf files with demos and examples (instead of database scripts or something similar). You would find . Mdf files in many tutorials, and this has nothing to do with ASP.NET MVC itself.

The examples you have seen most likely all use ADO. NET, which works the same in any application. Regardless of database provider , you should stress-test your web application to find out just how many concurrent users and how many requests per second you can handle.

Here, have a good article on improving performance with ASP. NET MVC web applications.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.