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
0 answers

C# WinForm with local mdf Database on Client-PC

I have some problems at the moment with an Applicaion of mine. I got the task to create a Application for display stock data. So i'd build a WinForm application with a local mdf Database. The Application works great on my developer machine. For…
0
votes
1 answer

My site is not accessible to the DB .mdf

My asp.net is not accessing the .mdf database file. Local site works but when you attach a server application is down when you click on the button (ADD/MYORDERS) that writes in the database (visit a link). My site is hosted HERE This is the…
0
votes
1 answer

WPF connection string for .mdf file database

I have a problem with publish of my WPF application. Database doesn't attach by project, and located in folder Debug, and connection string is :
Pushkin
  • 17
  • 1
  • 9
0
votes
1 answer

C# Windows Form Application is not publishing local database (.mdf)

I've made an Windows Form Application in Visual Studio with a local database, and as always it works fine when developing it but if I publish it and try to run on a different computer, it doesn't work. Here is my connection string in app.config: …
Stefan Hariton
  • 347
  • 4
  • 19
0
votes
0 answers

How to create mdf database file dynamicly using C# code by optional "Recovery model" option?

I have created C# code which creates a .mdf SQL Server database file and this code works just fine. There only few options are missing. Especially I need to choose either database "Recovery model" is full mode or simple mode and …
0
votes
1 answer

How to see the database name of each physical Mdf file?

I formatted my pc, so I lost a lot of MDF files(Databases), using a program I was able to recover a lot of .mdf files, the thing is that they have a different name. I have a list of mdf files, for example: folder: MDFiles Content: f324324234.mdf,…
user3044096
  • 171
  • 1
  • 17
0
votes
1 answer

SQL Server 2005 config file path of databases loaded

I need to find the path of the database (MDF) or at least the database logs loaded but for some reasons I cannot login through the SQL Server so I need to know if you know any file/config file that keeps the path of the databases or log file .
Michael
  • 6,377
  • 14
  • 59
  • 91
0
votes
0 answers

Local database in Visual Studio wpf, data adding doesnt work

I am trying to add some data to my empty table OBJEDNAVKY(columns:CisloStolu,Cena,Zaplacena,Nazev) in local database MDF (using Ado.Net Data Entity Model), in Visual Studio 2013. But it doesn't work. Can you find the problem? Here is the…
sustekj
  • 25
  • 7
0
votes
1 answer

Where to place database files in Visual Studio

If this question has been asked before please point me in the right direction. I am working with an MDF file which I attach to localdb in Visual Studio. However, when I run my application it is copied to the Debug folder (I know this is because the…
Munashe Tsododo
  • 247
  • 1
  • 5
  • 13
0
votes
0 answers

Crystal Report .mdf file "Failed to open the connection"

I'm creating an application with multiple .mdf User can navigate in different database. Changing connection in my application is working fine. But when i try to use my connection in Crystal Report, error comes out ReportError EDIT: Is there a way…
jayvee
  • 160
  • 2
  • 17
0
votes
1 answer

How to change data inside an mdf file in localdb

My question is similar to this, but I don't have a "real" Server only localdb from Microsoft SQL-Server Express: how can i see data in mdf file I have a (closed) tool I need to export data from to import it with groovy into a web application. The…
Fels
  • 1,214
  • 2
  • 13
  • 27
0
votes
1 answer

MDF table content is deleted when starting application from within VS

Very mysterious issue here. I have mdf-file in project with single table (double-clicking will show this): CREATE TABLE [dbo].[Table] ( [Id] DATETIME NOT NULL, [Version] NCHAR (20) NULL, PRIMARY KEY CLUSTERED ([Id]…
Sinatr
  • 20,892
  • 15
  • 90
  • 319
0
votes
1 answer

Entity Framework LocalDB connectionstring

I find it hard to understand how Entity Framework in Visual Studio is dealing with a LocalDB. In my project root folder I have a .mdf database file, let's call it MyDatabase.mdf I'm using the MVVM pattern in my WPF application, so in my Model…
QuantumHive
  • 5,613
  • 4
  • 33
  • 55
0
votes
1 answer

Update button returning all nulls

"Update" button is returning all nulls. I click "Edit" and everything displays ok. When I click "Update" it makes Columns: datetime, col1, col2 and col3 all nulls on the screen and in the "MDF". The "Delete" works fine. The "mdf" file is working…
noviscientia
  • 17
  • 1
  • 6
0
votes
2 answers

DataBindingSource best practices

I'm building an app in vs2013 using .net4.5. The app has multiple forms and a local MDF file with multiple tables. I was wondering what best practices are for binding the tables to controls. Should each table/form have it's own databindingsource,…