public int count()
 {
     using (var db = new MainDb())
     {
         return db.images.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.propertyListingTypes.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.carModelTypes.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.businessServiceTypes.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.stateTypes.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.optionTypes.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.jobCategoryTypes.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.listingCategoryLookups.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.memberRoleLookups.Count();
     }
 }

 public int count()
 {
     using (var db = new MainDb())
     {
         return db.listings.Count();
     }
 }

        /// <summary>
        /// Get First Item
        /// </summary>
        public StateTypeVo getFirst()
        {
            using (var db = new MainDb())
            {
                var res = db.stateTypes
                            .FirstOrDefault();

                return res;
            }
        }

        /// <summary>
        /// Get First Item
        /// </summary>
        public MemberRoleLookupVo getFirst()
        {
            using (var db = new MainDb())
            {
                var res = db.memberRoleLookups
                            .FirstOrDefault();

                return res;
            }
        }

        /// <summary>
        /// Find MemberRoleLookup matching the memberRoleLookupId (primary key)
        /// </summary>
        public MemberRoleLookupVo get(Guid  memberRoleLookupId )
        {
            using (var db = new MainDb())
            {
                var res = db.memberRoleLookups
                            .FirstOrDefault(p => p.memberRoleLookupId == memberRoleLookupId);

                return res;
            }
        }

 public bool delete(Guid memberRoleLookupId)
 {
     using (var db = new MainDb())
     {
         var res = db.memberRoleLookups
              .Where(e => e.memberRoleLookupId == memberRoleLookupId)
              .Delete();
         return true;
     }
 }

        /// <summary>
        /// Find Member matching the memberId (primary key)
        /// </summary>
        public MemberVo get(int  memberId )
        {
            using (var db = new MainDb())
            {
                var res = db.members
                            .FirstOrDefault(p => p.memberId == memberId);

                return res;
            }
        }

 public bool delete(int memberId)
 {
     using (var db = new MainDb())
     {
         var res = db.members
              .Where(e => e.memberId == memberId)
              .Delete();
         return true;
     }
 }

        /// <summary>
        /// Get First Item
        /// </summary>
        public CarModelTypeVo getFirst()
        {
            using (var db = new MainDb())
            {
                var res = db.carModelTypes
                            .FirstOrDefault();

                return res;
            }
        }

        /// <summary>
        /// Find ListingCategoryLookup matching the listingCategoryLookupId (primary key)
        /// </summary>
        public ListingCategoryLookupVo get(Guid  listingCategoryLookupId )
        {
            using (var db = new MainDb())
            {
                var res = db.listingCategoryLookups
                            .FirstOrDefault(p => p.listingCategoryLookupId == listingCategoryLookupId);

                return res;
            }
        }

        /// <summary>
        /// Find Listing matching the listingId (primary key)
        /// </summary>
        public ListingVo get(Guid  listingId )
        {
            using (var db = new MainDb())
            {
                var res = db.listings
                            .FirstOrDefault(p => p.listingId == listingId);

                return res;
            }
        }

        /// <summary>
        /// Find ListingStatusType matching the listingStatusTypeId (primary key)
        /// </summary>
        public ListingStatusTypeVo get(int  listingStatusTypeId )
        {
            using (var db = new MainDb())
            {
                var res = db.listingStatusTypes
                            .FirstOrDefault(p => p.listingStatusTypeId == listingStatusTypeId);

                return res;
            }
        }