SQL Server with .NET Framework

In this article I will explain how to use SQL Server with .NET Framework.
  • 1402

Introduction

The class library is contained in the file System.Data.dll.

Coding


VB.NET code

Imports System.Data.SqlClient
Dim myConnection As SqlConnection = New SqlConnection;();
myConnection.ConnectionString = myConnectionString
myConnection.Open()
//execute queries, etc
myConnection.Close()


C# code

using System.Data.SqlClient;
SqlConnection myConnection = new SqlConnection;();
myConnection.ConnectionString = myConnectionString;
myConnection.Open();
//execute queries, etc
myConnection.Close();


Standard

Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True;


Using MARS enabled

Server=tcp:[serverName].database.windows.net;Database=myDataBase;User ID=[LoginForDb]@[serverName];Password=myPassword;Trusted_Connection=False;Encrypt=True; MultipleActiveResultSets=True;

 

You may also want to read these related articles : here

Ask Your Question 

Got a programming related question? You may want to post your question here

Programming Answer here

Categories

More Articles

© 2020 DotNetHeaven. All rights reserved.