BaseTest

gistfile1.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data.SqlClient;

namespace MT.SmsNavigationFactory.Tests
{
    public abstract class BaseTest
    {
        protected void Delete(string sql)
        {
            using (var connection = new SqlConnection("Data Source=.;Initial Catalog=SmsNavigationFactory;Integrated Security=True;MultipleActiveResultSets=True"))
            {
                connection.Open();
                using (var command = new SqlCommand(sql, connection))
                {
                    command.ExecuteNonQuery();
                }
                connection.Close();
            }
        }

        protected T Create<T>(string sql)
        {
            T id;

            using (var connection = new SqlConnection("Data Source=.;Initial Catalog=SmsNavigationFactory;Integrated Security=True;MultipleActiveResultSets=True"))
            {
                connection.Open();

                using (SqlCommand command = new SqlCommand(sql, connection))
                {
                    var result = command.ExecuteScalar();
                    id = (T)result;
                }

                connection.Close();
            }

            return id;
        }
    }
}