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.
  • 2753

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

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.