/// <summary>
/// 创建具体数据库访问类
/// </summary>
/// <typeparam name="TProvider"></typeparam>
/// <param name="connectionString"></param>
/// <returns></returns>
#region Methods
public static DapperDB CreateDatabase <TProvider>(string connectionString) where TProvider : DbConnection
{
var db = new DapperDB(() =>
{
return(Activator.CreateInstance <TProvider>());
}
, connectionString);
return(db);
}
/// <summary>
/// 获取Datable（只限制Oracle数据库用）
/// </summary>
/// <param name="sql"></param>
/// <param name="p">Oracle动态参数</param>
/// <returns></returns>
public static DataTable ExecuteTable(this DapperDB db, string sql, OracleDynamicParameters p)
{
DataTable dt = null;
using (var conn = db.GetConnection())
{
dt = new DataTable();
dt.Load(conn.ExecuteReader(sql, p));
}
return(dt);
}
/// <summary>
/// 查询List接口（只限制Oracle数据库用）
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sql"></param>
/// <param name="p">Oracle动态参数</param>
/// <param name="isCount">是否返回总数</param>
/// <param name="recordCount">总数</param>
/// <returns></returns>
public static List <T> QueryList <T>(this DapperDB db, string sql, OracleDynamicParameters p, bool isCount, ref int recordCount)
{
List <T> list = null;
using (var conn = db.GetConnection())
{
list = conn.Query <T>(sql, p).ToList();
if (isCount)
{
recordCount = p.GetRecordCount();
}
return(list);
}
}
/// <summary>
/// 获取Datable
/// </summary>
/// <param name="sql"></param>
/// <param name="p">Oracle动态参数</param>
/// <param name="isCount"></param>
/// <param name="recordCount"></param>
/// <returns></returns>
public static DataTable ExecuteTable(this DapperDB db, string sql, OracleDynamicParameters p, bool isCount, ref int recordCount)
{
DataTable dt = null;
using (var conn = db.GetConnection())
{
dt = new DataTable();
dt.Load(conn.ExecuteReader(sql, p));
if (isCount)
{
recordCount = p.GetRecordCount();
}
}
return(dt);
}