Skip to main content

ADO.NET Connection

Declares an 'AdoNetConnection' that uses the 'System.Data.SqlClient.SqlConnection' provider to talk to SQL Server. The connection string targets a database named 'SportsData' on the local server with Windows Integrated Security. Replace 'Data Source' and 'Initial Catalog' with the server and database you need, or switch the provider string if you want a different ADO.NET data provider (for example, MySQL, PostgreSQL, or Oracle).

<Biml xmlns="http://schemas.varigence.com/biml.xsd">
<Connections>
<AdoNetConnection Name="AdoNetConnection" Provider="System.Data.SqlClient.SqlConnection, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" ConnectionString="Data Source=localhost;Initial Catalog=SportsData;Integrated Security=True;" />
</Connections>
</Biml>