/// <summary>
/// INSERT, UPDATE ve DELETE işlemleri için kullanılır.
/// </summary>
/// <param name="query"></param>
/// <param name="parameters"></param>
protected object ExecuteQuery(string query, List <DbParameter> parameters)
{
using (DbCommand queryCmd = SqlServerDB.GetSqlStringCommand(query))
{
addInParameters(parameters, queryCmd);
return(SqlServerDB.ExecuteScalar(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);
}
}
