/// <summary>
/// 执行一个DbCommand并返回DataSet
/// </summary>
/// <param name="comm"></param>
/// <returns></returns>
public static DataSet ExecuteCommand(this DbProviderFactory dbFactory, DbCommand comm, string connectionStringName)
{
DbConnection conn = dbFactory.CreateConnection(connectionStringName);
comm.Connection = conn;
DbDataAdapter adapter = dbFactory.CreateDataAdapter();
adapter.SelectCommand = comm;
try
{
DataSet ds = new DataSet();
adapter.Fill(ds);
return ds;
}
catch (Exception eX)
{
throw eX;
}
finally
{
if (ConnectionState.Open == conn.State)
conn.Close();
}
}
public static void FillDataSet(this DbConnection conn, DataSet dataSet, string tableName, string sql, MissingSchemaAction missingSchemaAction = MissingSchemaAction.Add)
{
using (var da = conn.CreateDataAdapter())
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = sql;
da.SelectCommand = cmd;
da.MissingSchemaAction = missingSchemaAction;
da.Fill(dataSet, tableName);
}
}
public static DataTable Query(this DbConnection conn, string sqlStatement, int start = 0, int maxRecords = 0)
{
DataSet ds = new DataSet();
IDbDataAdapter da = conn.CreateDataAdapter();
IDbCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlStatement;
da.SelectCommand = cmd;
da.Fill(ds);
return ds.Tables[0];
}
