/// <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); } }