Questions tagged [mdf]

Master Database File (.MDF) is the starting point of a SQL Server database. It is the primary data file and also points to the other files in the database.

See the Wikipedia article on Microsoft SQL Server.

Related Tags:

429 questions
0
votes
1 answer

Setting up a SQL Membership Provider and attaching the MDF file in Visual Studio 2008

I'm trying to set up a SQL Membership Provider for an ASP.NET MVC 1.0 and I'm having problems setting up the tables and stored procedures in the database. I've tried attaching both the applications current database and a blank database to my local…
0
votes
1 answer

is there a way to deploy simple vbnet program with database without using sql server?

I made this program on vbnet express 2012, using the built in data source, and when I deploy the program copying also the mdf file, the program won't work on the client machine. My client doesn't want to install SQL server on his machine, he only…
0
votes
0 answers

How to restore local database in ASP.Net web application using entity framework?

I want to add an option in my web application to restore database. this is StoredProcedure: ALTER PROCEDURE [Restore] @path NVARCHAR(MAX) AS BEGIN EXEC('ALTER DATABASE Kimiakesht SET OFFLINE') EXEC('ALTER DATABASE Kimiakesht SET…
Rasool Ghafari
  • 4,128
  • 7
  • 44
  • 71
0
votes
1 answer

.mdf file does not show in VS

I am using VS 2013 express for web. By using Code First Paradigm I stored data in LocalDB. Now file Movie.mdf has been created and shows data but this does not appear in App_Data folder. I refreshed it and restarted VS but still .mdf files does not…
user3461957
  • 163
  • 2
  • 5
  • 14
0
votes
5 answers

Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005

The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the…
xantrus
  • 1,975
  • 1
  • 22
  • 44
0
votes
1 answer

aspnet_regsql not working at all

I would like to create the ASP.NET User database template on a database of my own, because I'd like to fully untegrate the user system with the rest of my DB. As I've read, i needed to use the aspnet_regsql tool. I put all the options (because my…
xantrus
  • 1,975
  • 1
  • 22
  • 44
0
votes
1 answer

Should I put my .mdf and .ldf files from my code into Visual Studio Team Services repository

If I create a .sqlproj file that contains all my sql objects, why would I need to put my mdf, ldf files into VS Team Services source repository? Doesn't the .mdf contain all the data? If that is true then I probably wouldn't want to store all the…
chuckd
  • 13,460
  • 29
  • 152
  • 331
0
votes
0 answers

why use a mdf if using a sqlproj in MVC project

I set up a MVC 4 project and created a sqlproj to store all my database objects. I can publish it to sql express and then to Azure just fine. I know there is a .mdf file for an actual database that gets placed into the app_data folder in my…
chuckd
  • 13,460
  • 29
  • 152
  • 331
0
votes
1 answer

Error when opening app on different computer

I have just finished an app that is using a database.mdf. Everything is working well, but when I open the app on a different computer, I'm getting the following error: "A network-related or instance-specific error occurred while establishing a…
user2851021
  • 71
  • 1
  • 9
0
votes
2 answers

not connecting because read-only (sql server, mdf file)

this is a different question concerning: add a connection to database not working, asp.net to mdf i am unable to connect because of the noted error message the database must be read only? but when i click the properties of the file read only is not…
Alex Gordon
  • 57,446
  • 287
  • 670
  • 1,062
0
votes
1 answer

Filter a datagrid to a value returned from a bindingNavigator bound to another datasource

I have a form with a DataSource bound to a bindingNavigator. This DataSet includes a unique id which I want to use (when navigating to another record) to filter a second dataset and populate a datagrid with. I am using an mdf file db with a…
khany
  • 1,167
  • 15
  • 33
0
votes
1 answer

.mdf and web client using REST

This is probably one of the most amateurish questions, but our final project requires us to connect to a SQL Server database (.mdf) via a web service (either SOAP or REST) and then consume it and I am having the hardest time wrapping my head around…
0
votes
1 answer

Changes made externally to database is not reflected back

I am trying to build a website in Visual Studio 12 using a local db(*.mdf file) but once i run the site to test it.. and insert data through the website into my db, after a few runs, the changes are not reflected in the db. how can i fix this?
Korak
  • 1
  • 3
0
votes
2 answers

How to connect to local database and update a dataset in C#?

I have stored some products (a product contains: unique id - primary key, name, price, quantity) in a local database file (Stock.mdf, table for the products is called 'table'). The file is in my project folder in Visual Studio. When someone call an…
Hack4Life
  • 563
  • 1
  • 11
  • 34
0
votes
1 answer

How to move database and attach it to SQL Server 2008

I am not able to attach a database to a SQL Server 2008 on different machine. I moved the .mdf and .ldf files after detaching the database from one computer to another. When I try to attach the database on new machine the database does not show up…
user2149838
  • 49
  • 1
  • 1
  • 8