Last post Apr 24, 2012 05:08 PM by adamturner34
Apr 24, 2012 02:59 PM|LaraCroft1998|LINK
I have been following this tutorial: http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/accessing-your-model's-data-from-a-controller,
and I am on that page. I am using 'Visual Web Developer 2010' The server successfully created the .sdf database but when I try to open it by double - clicking it says 'Operation could not be completed'. The database also has a icon of a page with dashed lines
around it, which I think would mean something is wrong?
I also noticed I can not create .sdf databases, but only .mdf ones. It has really become annoying, I have installed all three of things listed in the blue box above the tutorial, and I have tried restarting Visual Web Developer 2010.
Please help me.
Apr 24, 2012 03:41 PM|adamturner34|LINK
.sdf is for sql compact edition. You can't "open it", per se, but merely use it...create tables, indexes, views, etc...It's not an openable object.
.mdf is for sql server express edition. You can open these with management studio but not by double clickign on it. It has to be attached to the database server.
If you can't create .sdf's, I would uninstall and reinstall the SQL Server CE component or download it from here:
Apr 24, 2012 03:56 PM|LaraCroft1998|LINK
Didn't work, I uninstalled SQL Server Compact 4 and reinstalled it. When I am Visual Developer 2010 I can not edit the tables inside it because when I double click 'db.sdf' (which the script created) it says "Operation could not be completed." Nor can I
create them. :(
Apr 24, 2012 04:05 PM|adamturner34|LINK
Apr 24, 2012 04:40 PM|LaraCroft1998|LINK
Damn, still not working, should I uninstall visual web developer and reinstall? and if so can I transfer my projects (I think this is a stupid question but I don't know where thye are stored LOL)
Apr 24, 2012 05:08 PM|adamturner34|LINK
Yeah. Just open one of the projects, right-click on the solution and there should be an option to "Open in Windows Explorer" That'll show you where the files are located.