.net core 连接mysql 五：创建SysUserRepository实现接口ISysUserRepository

 

 

 

using fjxw.model;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace fjxw.dal
{
public class SysUserRepository : ISysUserRepository
{
private CoreDbContext context;
public SysUserRepository(CoreDbContext _context)
{
this.context = _context;
}
public void DeleteUser(int userID)
{
sysuser user= context.SysUser.Find(userID);
context.Remove(user);
}
private bool disposed = false;
protected virtual void Dispose(bool disposing)
{
if (this.disposed)
{

if (disposing)
{
context.Dispose();
}
}
this.disposed = true;
}
public void Dispose()
{
Dispose(true);
GC.SuppressFinalize(this);

}
public sysuser GetUserByID(int userID)
{
return context.SysUser.Find(userID);
}

public IEnumerable<sysuser> GetUsers()
{
return context.SysUser.ToList();
}

public void InsertUser(sysuser user)
{
context.SysUser.Add(user);
}

public void Save()
{
context.SaveChanges();
}

public void UpdateUser(sysuser user)
{
context.Entry(user).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
}
}
}