protected void PrepareConnection()
{
if (_connection == null)
{
_connection = new SqlConnection(ConnectionStringProvider.GetConncetionString());
}
if (_connection.State != ConnectionState.Open)
{
_connection.Open();
}
}