Jasinski Technical Wiki

Navigation

Home Page
Index
All Pages

Quick Search
»
Advanced Search »

Contributor Links

Create a new Page
Administration
File Management
Login/Logout
Your Profile

Other Wiki Sections

Software

PoweredBy

Connection Strings - SQL Server

RSS
Modified on Fri, Nov 29, 2019, 1:05 AM by Administrator Categorized as SQL Server
DescriptionExample
SQL Server AuthenticationData Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Windows AuthenticationData Source=myServerAddress;Initial Catalog=myDataBase;Integrated Security=SSPI;

For much more detail, see www.connectionstrings.com

Entity Data Model

<add
  name="EntityDataModel"
  connectionString="metadata=res://*/EntityDataModel.csdl|res://*/EntityDataModel.ssdl|res://*/EntityDataModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;myConnectionString&quot;"
  providerName="System.Data.EntityClient"
  />

Code First

<add name="SmartDataModel" 
      connectionString="myConnectionString"
      providerName="System.Data.SqlClient"
      />

ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2019, Patrick Jasinski.