/// <summary>
/// StoredProcedure işlemleri için kullanılır.
/// </summary>
/// <param name="spName"></param>
/// <param name="parameters"></param>
protected object ExecuteByStoredProcedure(string spName, List <DbParameter> parameters)
{
using (DbCommand queryCmd = SqlServerDB.GetStoredProcCommand(spName))
{
addInParameters(parameters, queryCmd);
return(SqlServerDB.ExecuteDataSet(queryCmd));
}
}
protected List <T> GetListByQuery <T>(string query) where T : new()
{
using (DbCommand queryCmd = SqlServerDB.GetSqlStringCommand(query))
{
DataSet ds = SqlServerDB.ExecuteDataSet(queryCmd);
var rows = ds.Tables[0].DataTableToObjectList <T>();
return(rows);
}
}
protected List <T> GetListByStoredProc <T>(string storedProcName) where T : new()
{
using (DbCommand sprocCmd = SqlServerDB.GetStoredProcCommand(storedProcName))
{
DataSet ds = SqlServerDB.ExecuteDataSet(sprocCmd);
var rows = ds.Tables[0].DataTableToObjectList <T>();
return(rows);
}
}
