using (var connection = new SqlConnection("Server=(local)\MSSQL01;Database=AdventureWorks2016;Integrated Security=True;"))
{
var results = connection.ExecuteQuery("SELECT BusinessEntityId, Title, FirstName FROM [Person].[Person] WHERE PersonType = 'IN';");
return results;
}
using (var connection = new SqlConnection("Server=(local)\MSSQL01;Database=AdventureWorks2016;Integrated Security=True;"))
{
var results = connection.ExecuteQuery("SELECT BusinessEntityId, Title, FirstName FROM [Person].[Person] WHERE PersonType = 'IN';");
return results;
}