Hi, first of all, thanks again for your book...
I have read your appendix 2 of your book since I have SQL Server 2012 Enterprise Edition... and still have not figure out how to attach it without problem into visual studio...
when I have SQL Server Express, I have a very good life!!!... when I bought SQL Server 2012 Enterprise Edition, everything wants to fight with me!...
I create a database in SSMS, and then I want to create an entity model in visual studio... it first says "this file is in use. enter a new name or close the file that's open in another program"... then I take offline the database in SSMS... and new error is " can't open database ((path database)) requseted by the login. The login faild.
login faild for user "((Pc Name and User))" "....
I have asked this question is forum general asp.net... but I've done it with your book too... and again I gain nothing :(...
I also use Visual Studio 2013 Ultimate....
if this question is not related to your book, please tell me where should I ask it...
I really need it...
thanks in advance....

I think , I should use "Microsoft SQL Server" datasource in wizard, not "Microsoft SQL Server Database File (SqlClient)"... the second one is the direct calling of a database file, which is not the right way for commercial version of SQL Server 2012 ( as I told! ... not sure!)... the second one seems to be work just with SQL Server Express Edition...
I hoped this helps another people in future:)
thanks...

Hi there,

Yes, that's correct. When you attach a database to SQL Server, you can no longer connect to the .mdf file directly, Instead, you need to use a connection string that points to a SQL Server instance.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!