protected List <T> ExecuteStoreQuery <T>(string strQuery, List <SqlParameter> listDbParameters = null, string strFunctionName = "") { this.PrintDetailsInTrace(strQuery, listDbParameters, strFunctionName); using (cricketEntities objCommonEntity = new cricketEntities()) { var lstResult = objCommonEntity.Database.SqlQuery <T>(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null).ToList(); return(lstResult); } }
protected void ExecuteFunction(string strQuery, List <ObjectParameter> listDbParameters = null, string strFunctionName = "", string strDB = "") { this.PrintObjectParaDetailsInTrace(strQuery, listDbParameters, strFunctionName); using (cricketEntities objCommonEntity = new cricketEntities()) { objCommonEntity.Database.ExecuteSqlCommand(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null); } }
protected int ExecuteStoreCommand(string strQuery, List <SqlParameter> listDbParameters = null, string strFunctionName = "", char charReqLastId = 'N') { this.PrintDetailsInTrace(strQuery, listDbParameters, strFunctionName); using (cricketEntities objCommonEntity = new cricketEntities()) { int intLastInsertedId = 0; if (charReqLastId == 'Y') { strQuery += "; DECLARE @intLastld int; SET @intLastld = SCOPE_IDENTITY(); SELECT @intlastld; "; if (listDbParameters == null) { listDbParameters = new List <SqlParameter>(); } intLastInsertedId = objCommonEntity.Database.SqlQuery <int>(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null).FirstOrDefault(); HttpContext.Current.Trace.Warn("\n " + strFunctionName + " => Lastlnsertedld " + intLastInsertedId.ToString()); } else { objCommonEntity.Database.ExecuteSqlCommand(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null); //SqlQuery<int>(strQuery, (listDbParameters != null) ? listDbParameters.ToArray() : null); } return(intLastInsertedId); } }