protected DbDataReader GetDataReader(DbConnection dbConnection, string sql)
{
DbCommander dbCommander = new DbCommander(dbConnection, System.Data.CommandType.Text, sql);
DbDataReader dataReader = dbCommander.ExecteReader();
return(dataReader);
}
protected object GetScalar(DbConnection dbConnection, string sql)
{
DbCommander dbCommander = new DbCommander(dbConnection, System.Data.CommandType.Text, sql);
object obj = dbCommander.ExecuteScalar();
return(obj);
}
public void ExecuteNonQuery(DbConnection dbConnection, string sql, Dictionary <string, object> paramaters = null, bool disposeConnection = true)
{
#if disposeConnection
using (dbConnection)
#endif
{
DbCommander dbCommander = new DbCommander(dbConnection, System.Data.CommandType.Text, sql);
if (paramaters != null)
{
var cmdParams = this.BuildCommandParameters(paramaters);
if (cmdParams != null)
{
dbCommander.DbCommand.Parameters.AddRange(cmdParams.ToArray());
}
}
dbCommander.ExecuteNonQuery();
}
}
public async Task <int> InteralExecuteNonQuery(DbConnection dbConnection, string sql, Dictionary <string, object> paramaters = null, bool disposeConnection = true, bool async = false)
{
#if disposeConnection
using (dbConnection)
#endif
{
DbCommander dbCommander = new DbCommander(dbConnection, System.Data.CommandType.Text, sql);
if (paramaters != null)
{
var cmdParams = this.BuildCommandParameters(paramaters);
if (cmdParams != null)
{
dbCommander.DbCommand.Parameters.AddRange(cmdParams.ToArray());
}
}
int result = async ? await dbCommander.ExecuteNonQueryAsync() : dbCommander.ExecuteNonQuery();
return(result);
}
}