Code with C | Programming: Projects & Source Codes › Forums › ASP.NET › Asp.net using C#: What is MDF and how to connect ?
November 24, 2016 at 1:05 pm #11152
Can anyone tell what is an mdf format database?
what are the codes to connect to such a database and what is the best database to connect to asp.net application?
November 24, 2016 at 1:05 pm #11153
MDF is the format that Microsoft Access uses. You can set up an ODBC connection, or with Visual Studio I think there’s a way to establish a connection via some GUI options. As for actual code, I haven’t touched .NET in ages, so I have no idea Smile
The best database is a tricky question, because that depends on scalability, cost, timelines, etc. For a simple setup, try a real database like MySQL or PostgreSQL.
November 24, 2016 at 1:06 pm #11154
MDF is not Access, it is MS SQL server database. (Master Data File)
When you create a database in MSSQL Server it will create one MDF file and one LDF file, the LDF is a log file.
when you create a database with SQL Server Express, the MDF File will be added to your ASP.Net application.
When you start working with ASP.Net, the best choice in DB Server is a SQL Server database. You can use MSSQL Express, or Compact databases.
Advantage is that you can use Entity Framework and that is in my opinion the fastest way to set up a database and a good way to use that database, especially for a beginner.
November 24, 2016 at 1:06 pm #11155
Use the ADO.NET EntityFramework to make your life a lot easier.
Anyway, if you’re going to make something that involves multiple users and multiple queries being executed on the database at any given time, don’t use Access or you’ll run into concurrency issues sooner or later. Obviously MSSQL works best with .NET, as they’re both Microsoft technologies and they tend to give that little bit of extra compatibility with their own products. However, MySQL or any other ODBC database should work just fine.
You must be logged in to reply to this topic.