public DataTable ExecuteQuery(string sqlText)
{
DataTable dataTable = new DataTable();
var cmd = conn.CreateCommand();
cmd.CommandText = sqlText;
var adapter = new DmDataAdapter(cmd);
adapter.Fill(dataTable);
return(dataTable);
}
public DataTable ExecuteProcedureQuery(string sqlText, params DbParameter[] parameters)
{
DataTable dataTable = new DataTable();
var cmd = conn.CreateCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sqlText;
cmd.Parameters.AddRange(parameters);
var adapter = new DmDataAdapter(cmd);
adapter.Fill(dataTable);
return(dataTable);
}
/// <summary>
/// 获取数据适配器实例
/// </summary>
/// <returns>数据适配器</returns>
protected override IDbDataAdapter GetDataAdapter(IDbCommand command)
{
IDbDataAdapter ada = new DmDataAdapter((DmCommand)command);
return(ada);
}
