After seeing a lot of things in the internet I haven't found any explanation between the two file types:
.sdf would be a compact version of SQL Server (
.mdf) I believe. Still they appear utterly different.
Partial quote (full): 'First of all it should be "|DataDirectory|ASPNETDBContext.mdf" (notice the extension difference). Your applic...'
Both tutorials have the connection string to
<add name ="MovieDBContext" connectionString ="Data Source=|DataDirectory|Movies.sdf" providerName ="System.Data.SqlServerCe.4.0" /> <add name ="MusicStoreEntities" connectionString ="Data Source=|DataDirectory|MvcMusicStore.sdf" providerName ="System.Data.SqlServerCe.4.0" />
My question is what to use where and when? More over why to use which where.
SQL Server Compact (sdf files) popular in Windows phone for storing some data (small count of data), also it could be used in web sites, but it has poor performance, even SQLite is better.
SQL Server (mdf files) used in big sites with a lot of data. Its more powerful, but cant be used in phones and must be installed on servers.