/// <summary> /// Get a EF6.InvtBatchADJ_Details object from the database using the given DetailsId /// </summary> /// <param name="detailsId">The primary key value</param> /// <returns>A EF6.InvtBatchADJ_Details object</returns> public static EF6.InvtBatchADJ_Details Get(Guid detailsId) { EF6.InvtBatchADJ_Details result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.InvtBatchADJ_Details.Where(x => x.DetailsId == detailsId).AsNoTracking().FirstOrDefault(); } return(result); }
/// <summary> /// Get a EF6.InvtBatchADJ_Details object from the database using the given QueryString /// </summary> /// <param name="detailsId">The primary key value</param> /// <returns>A EF6.InvtBatchADJ_Details object</returns> public static EF6.InvtBatchADJ_Details Get(string whereClause) { EF6.InvtBatchADJ_Details result = null; using (var ctx = new EF6.RT2020Entities()) { result = ctx.InvtBatchADJ_Details .SqlQuery(string.Format("Select * from InvtBatchADJ_Details Where {0}", whereClause)) .AsNoTracking() .FirstOrDefault(); } return(result); }