How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?

by

A great resource I always keep around is connectionstrings.com.
It’s really handy for finding these connection strings when you can’t find an example.

Particularly this page applied to your problem

Attach a database file on connect to a local SQL Server Express instance

Driver={SQL Native Client};Server=.\SQLExpress;AttachDbFilename=c:\asd\qwe\mydbfile.mdf; Database=dbname;Trusted_Connection=Yes;

More Related Contents:

  1. Unable to cast object of type ‘System.DBNull’ to type ‘System.String`
  2. Insert 2 million rows into SQL Server quickly
  3. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  4. How to set session timeout in web.config
  5. Unable to connect to ASP.Net Development Server issue
  6. What does N’ stands for in a SQL script ? (the one used before characters in insert script)
  7. Cannot find namespace ‘System.Data.SqlServerCe’
  8. Post Publish Events
  9. Populate TreeView from DataBase
  10. Databind a dropdownlist
  11. converting a base 64 string to an image and saving it
  12. Bulk-deleting in LINQ to Entities
  13. WebClient.DownloadString() returns string with peculiar characters
  14. How to fix “The ConnectionString property has not been initialized”
  15. Selectively use default JSON converter
  16. ASP.NET MVC – How to show unauthorized error on login page?
  17. HttpContext.Current.Session is null in Ashx file
  18. Calling a method in parent page from user control
  19. How to make Check Box List in ASP.Net MVC
  20. GridView bound with Properties of nested class
  21. Why is my ClaimsIdentity IsAuthenticated always false (for web api Authorize filter)?
  22. Date vs DateTime
  23. How can I trigger/refresh my main .RAZOR page from all of its sub-components within that main .RAZOR page when an API call is complete?
  24. The model item passed into the dictionary is of type ‘mvc.Models.ModelA’ but this dictionary requires a model item of type ‘mvc.Models.ModelB‘
  25. Value cannot be null. Parameter name: items (in Dropdown List) ASP.NET MVC5
  26. Get the current user, within an ApiController action, without passing the userID as a parameter
  27. ASP.NET – AppDomain.CurrentDomain.GetAssemblies() – Assemblies missing after AppDomain restart
  28. WebAPI Request Streaming support
  29. Can I reuse HttpWebRequest without disconnecting from the server?
  30. Cast an Anonymous Types in Object and retrieve one Field

Leave a Comment