I am a new bird in asp.net MVC. I know that SQL Server Compact edition is used as the database. I wanted to know if SQL Server can be used and if YES then how it can be used? Another thing I want to know is how the database works when the asp.net mvc project is deployed? Do we have to change some connection strings in \[code\]web.config\[/code\] file when project is deployed? Please help, as to how it exactly works.