Where is aspnetdb.mdf located

You can do this on your local machine by running aspnetregsql. Net framwork. If you have full control on your hosted server, then install the same way, otherwise your hosting provider will have to assist some offer the installation as an option via their Control Panel.

Set up a connection string that points explicitly at the SQL Server database i. I've put a specific example from one of my own web. The live web. Hope this helps! Thank you Dr. Bromberg for the extensive material you've pointed me to. I have downloaded the code and created a web site on my local Visual Studio server.

I have modifed the web. When I run the Default. Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. NET Core at my organisation and require them to submit their work to a grading website with a ZIP of their website folder.

This will be far easier if all files are located in the same directory for local websites. So far this has been a limiting factor in effectively and efficiently teaching the students using this method. Sorry, something went wrong. NET Core specifically. The Entity Framework team may know how to change the default location SQL Server uses cc divega ajcvickers , but I'm not sure such an option is easy to find. As far as I remember the way this worked in past versions of ASP. NET Core sets it. Cc bricelam who may remember.

For example, directly deleting the files would cause errors hard to recover from. Using a real embedded database like SQLite as natemcmaster suggest might be a better solution for this scenarios.

For educators that want to teach students to use a "real" database server, Docker is a good way to run SQL Server on Linux. But for the purposes of submitting assignments with an embedded database, SQLite is seems like the most viable option here. We periodically close 'discussion' issues that have not been updated in a long period of time. We apologize if this causes any inconvenience. We ask that if you are still encountering an issue, please log a new issue with updated information and we will investigate.

Skip to content. Star New issue. Viewed 6k times. There is a default connectionstring in the web. It might be using that.

Add a comment. Active Oldest Votes. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Does ES6 make JavaScript frameworks obsolete?