Local SQL Express Instance to Attach a Database File
In this article I am going to explain about how to create connection string using local SQL server express instance to attach a database file in .NET framework.
Introduction
Here I am explaining how to create connection string by using local SQL server express instance to attach a database file in .NET framework
To create connection string by using local SQL server express instance to attach a database file in .NET framework we need to put path and filename which you want to attach, your database name, and set the state of Trusted connection yes.
Syntax
Server=.\SQLExpress;AttachDbFilename=D:\vipendra\sql\basic\file1.mdf;Database=db; Trusted_Connection=Yes;
|
Further Readings
You may also want to read these related articles :
Ask Your Question
Got a programming related question? You may want to post your question here
Programming Answers here