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:

MS Management Studio

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=MACHINENAME\SQLEXPRESS; Initial Catalog=myFirstDB; Integrated Security=true;
  • 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:

Create New Data Source

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