예제 #1
0
        /// <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);
        }
예제 #2
0
        /// <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);
        }