Geek Answers Handbook

Can't add a local SQL database to VS2010 project?

I read and did exercises in Visual Studio 2010 Professional C#. Everything worked until I came across an exercise that asked me to create a local SQL database (.sdf). When I add it, it gives me an error message; "The data provider needed to connect to the local data file cannot be found. The file will be added to the project, but the typed DataSet associated with the file will not be generated." It will add the database, but whenever I try to access it, it gives me another error message:

"The operation could not be completed. Unspecified error."

At first I thought it was a matter of reinstallation SQL Server Compact 3.5 SP2. Tried this and no luck. Not sure what to do next.: \

Optionally: Windows XP x32 Visual Studio Professional 2010 SQL Server compact 3.5 SP2

+5
source share
2 answers

Try this link. I just started an ASP.NET web application, and I used this article to configure some entity frameworks. I love it. Hope this helps.

http://weblogs.asp.net/dotnetstories/archive/2011/03/01/using-stored-procedures-with-entity-framework-in-an-asp-net-application.aspx

+1
source

Are you using Entity Framework? If so, are you doing Code First or Database First?

This is an example of using MVC3, but it can be easily ported to other project models and is easily tracked: http://www.asp.net/mvc/tutorials/getting-started-with-aspnet-mvc3/cs/adding-a-model

Entity Framework, , , : http://www.asp.net/mvc/tutorials/getting-started-with-ef-using-mvc

+1

More articles:


All Articles