private IDbCommand CreateCommond(ISqlDocker container)
{
var cmd = this.conn.GetIDbCommand();
cmd.CommandText = container.Sql;
cmd.CommandType = container.CommandType;
this.SetParameter(cmd.Parameters, container.Parameters);
return(cmd);
}
public void ExecuteScalar <T>(ISqlDocker sqlDocker, out T value)
{
value = default(T);
var con = GetIDbConntion();
var cmd = CreateCommond(sqlDocker);
using (var read = cmd.ExecuteReader())
{
while (!read.IsClosed && read.Read())
{
value = (T)Convert.ChangeType(read.GetValue(0), typeof(T));
}
}
}
public IEnumerable <T> ExecuteReader <T>(ISqlDocker sqlDocker) where T : new()
{
T entity = new T();
var list = new List <T>();
var con = GetIDbConntion();
var cmd = CreateCommond(sqlDocker);
using (var read = cmd.ExecuteReader())
{
var rde = new ReaderDataEntity <T>(read);
return(rde.ConvertDataEntity());
}
}
public void ExecuteNonQuery(ISqlDocker sqlDocker, out int row)
{
IDbCommand cmd = CreateCommond(sqlDocker);
try
{
row = cmd.ExecuteNonQuery();
}
//catch (Exception ex) { }
finally
{
CloseConn(this.conn);
}
}
