public UserDetail GetByPK(int id) { using (UserEntities context = DbContextFactory.Create()) { return(context.UserDetails.FirstOrDefault(x => x.UserId == id)); } }
public int GetCount() { using (UserEntities context = DbContextFactory.Create()) { return(context.UserDetails.Count()); } }
public static UserEntities Create() { string connectionString = "metadata=res://*/User.csdl|res://*/User.ssdl|res://*/User.msl;provider=System.Data.SqlClient;provider connection string=\";data source=.;initial catalog=User;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework\";"; UserEntities context = new UserEntities(connectionString); return(context); }
public void Update(UserDetail userDetail) { using (UserEntities context = DbContextFactory.Create()) { context.Entry(userDetail).State = EntityState.Modified; context.SaveChanges(); } }
public void Insert(UserDetail userDetail) { using (UserEntities context = DbContextFactory.Create()) { context.Set <UserDetail>().Add(userDetail); context.Entry(userDetail).State = EntityState.Added; context.SaveChanges(); } }
public List <UserDetail> GetAll() { using (UserEntities context = DbContextFactory.Create()) { IQueryable <UserDetail> query = context.Set <UserDetail>(); var list = query.ToList(); return(list); } }
public void DeleteByPK(int id) { using (UserEntities context = DbContextFactory.Create()) { var userDetail = context.UserDetails.FirstOrDefault(x => x.UserId == id); if (userDetail == null) { return; } context.Entry(userDetail).State = EntityState.Deleted; context.SaveChanges(); } }