Database error ASP.NET

Question

I have my projects setup as follows (repository pattern):

myProj.Data (Contains the xDB.mdf) [Library]
myProj.Service (Uses myProj.Data) [Library]
myProj.WebApp (Uses myProj.Service) [ASP.NET Website]

In 1. I access my Database via Linq to Sql. The app.config looks like this:

<add name="XDbConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\XDb.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient" />

When I try to retrieve some data via the web, I get this error thrown from the Service Project:

An attempt to attach an auto-named database for file D:\MyProject\XDb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.

From this code:

return (from p in repository.GetPostMedia() where p.PostId == postId select p).ToList();

James · Accepted Answer · 2010-01-31 21:26:30Z

2

Check in Management Studio that you don't have that database already attached, if so detach it and try again.

answered Jan 31, 2010 at 21:26

James

82.4k19 gold badges172 silver badges245 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shawn Mclean · Accepted Answer · 2010-02-02 15:06:49Z

0

I moved the database from the myProj.Data into myProj.Web App_Data folder and it worked.

answered Feb 2, 2010 at 15:06

Shawn Mclean

57.5k97 gold badges283 silver badges412 bronze badges

Collectives™ on Stack Overflow

Database error ASP.NET

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related