private static void DbAction(Action <GN_KASIFEntities> action)
{
using (var context = new GN_KASIFEntities())
{
action(context);
}
}
private static void PrepareAndExecuteQuery <T>(ref List <T> entityObj, string queryContent, string[] parameterNames, object[] parameterValues)
{
try
{
GN_KASIFEntities EntityObj = new GN_KASIFEntities();
if (parameterNames != null && parameterValues != null)
{
SqlParameter[] SqlParameters = new SqlParameter[parameterNames.Length];
for (int i = 0; i < parameterNames.Length; i++)
{
SqlParameters[i] = new SqlParameter(parameterNames[i], parameterValues[i]);
}
entityObj = EntityObj.Database.SqlQuery <T>(queryContent, SqlParameters).ToList <T>();
}
else
{
entityObj = EntityObj.Database.SqlQuery <T>(queryContent).ToList <T>();
}
}
catch (Exception ex)
{
throw ex;
}
}
