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