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();
}
}
