SQL Server with .NET Framework
In this article I will explain how to use SQL Server with .NET Framework.
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