entityframeworktutorial
Pulled Copy - Cannot Attach DB
Greetings!
I pulled a copy of this to learn a little more about EF6 and it's possibilities. After extracting the ZIP, I was unable to attach the database to my MSSQL 2019 instance. I checked permissions and ensured MSSQL have full rights to the directory and file. But, no matter what I do, attach fails with an file access error.
The same is happening to me right now... SQL Server asks for a log file as well apart from the mdf....
Check this out: https://www.mssqltips.com/sqlservertip/1894/attach-sql-server-database-without-log-file/
it's a very simple solution!
Right click on SchoolDB.mdf -> select Properties -> go to Security tab -> make sure local users, admin and other users has full rights, if not then edit permissions and check full control checkbox and click ok. After this you should be able to attach SchoolDB.mdf file.
The same is happening to me right now... SQL Server asks for a log file as well apart from the mdf....
Check this out: https://www.mssqltips.com/sqlservertip/1894/attach-sql-server-database-without-log-file/
it's a very simple solution!
it worked like a breeze
hello iwas able to attach the mdf file by slecting the script option and i comment out the line for the ldf and it added it autonatically but my issue is when i try to run your program i get namespace error why? your readme file just says connect in app config to my server which i did add the mdf file which i did and then run the program but it fails w/ namespace erros
also where is your form.cs and form desgn? i dont see it in explsor solutin i am using 2019 that should not be an issue thxz
i just deleted your edmx and added my own and i still cant display it why
when i added the new edm i named it School and the test connection is good so why the erros?
i was able to crete th edmx diagram but the code has all kinds of errors so unless someone can jhelp me then i iwll just leave it thank you
i was able to crete th edmx diagram but the code has all kinds of errors so unless someone can jhelp me then i iwll just leave it thank you
Send error details to [email protected], we will help you out.
this email address is not good
i was able to crete th edmx diagram but the code has all kinds of errors so unless someone can jhelp me then i iwll just leave it thank you
iwqs told from github repo response to write to you here
i follow your very simple steps i download your project and unzip i open it in VS2019 i put my computer db server name in app config i delete the edmx and made my own and called the model School i then test the db connection its good and i see the edmx diagram in VS but there all kinds of entity type erros it seems like 50 erros i see the SchoolDBEntities in the exploer and it gives errors in the code
hope this is detailed for you to debug
kind regards Lisa