public IDbConnector Execute(
ISqlCommand sqlCommand
)
{
this.ResetStateProperties();
this.Close();
using (var Connection = this.OpenSqlConnection())
{
using (var cmd = sqlCommand.GenerateSqlCommandInstance <System.Data.SqlClient.SqlCommand>())
{
cmd.Connection = Connection;
this.AffectedRowCount = cmd.ExecuteNonQuery();
}
this.GetAndAssignLatestID(Connection);
Connection.Close();
}
return(this);
}
public IDbConnector Read(
ISqlCommand sqlCommand,
out IDbTable dbTable
)
{
this.ResetStateProperties();
this.Connection = this.OpenSqlConnection();
using (var cmd = sqlCommand.GenerateSqlCommandInstance <System.Data.SqlClient.SqlCommand>())
{
cmd.Connection = this.Connection;
this.DataAdapter = this.GetDataAdapter(cmd);
this.CommandBuilder = this.GetCommandBuilder(this.DataAdapter);
var DataTable = new System.Data.DataTable();
this.DataAdapter.Fill(DataTable);
dbTable = new DbTable(DataTable);
}
this.Connection.Close();
return(this);
}