SQL Database Example

Let's say we have a SQL Server with the name of SQLEXPRESS. We have to create a database in this server in order to use it for data binding. One way to do it is by using SQL Management Studio.

Let's create a database called myFirstDB:

Now we can connect to to it and use it for data-driven testing.

1. Load the Create New DataSource menu.
2. Choose Database.
3. For Provider, select SqlClient Data Provider.
4. Here's an example for Connection String:

• Data Source is the name of the SQL Server.
• Initial Catalog is the named of the Database.

Of course you can write many different connection strings. See here for more examples.

Customize the Friendly Name as desired:

Click OK and the new data source should appear in the Data Sources list.