.sdf

Local Databases in .Net

Good Afternoon, I am looking to add a local database file (.sdf) into my .Net Project, so i go right click on my project, click "Add" -> "New Item", select "Local Database" and rename it to what i want. I then click the "Add" button and get the following error "The data provider required to connect to the local data file could not be f...

How do I write and run an upgrade script for .sdf databases?

How do I write and run an upgrade script for .sdf databases? Would sqlcmd be able to do that? I am not trying to upgrade the version of the database file. I am trying to upgrade the schema and data inside of it. ...