机遇屋-.net core 使用EF

.net core 使用EF

作者：ych

#### 引用库
```
Install-package Microsoft.EntityFrameworkCore.SqlServer
```
#### 一.普通模式

##### 创建model
```
[Table("Live_admin")]
    public class Live_admin
    {
        public int Id
        {
            get { return id; }
            set { id = value; }
        }
        public string Uid
        {
            get { return uid; }
            set { uid = value; }
        }
        public string Pwd
        {
            get { return pwd; }
            set { pwd = value; }
        }
    }
```

##### appsetting.json
```
{
  "Logging": {
    "IncludeScopes": false,
    "LogLevel": {
      "Default": "Warning"
    }
  },
  "ConnectionStrings": {
    "TestConnection": "Data Source=127.0.0.1;Database=BPM;User ID=root;Password=123456;pooling=true;CharSet=utf8;port=3306;sslmode=none",
    "Redis": "127.0.0.1:6379"
  },
  "Appsettings": {
    "SystemName": "JIYUWU .NET CORE6.0",
    "Date": "2019-06-28",
    "Author": "Chang"
  },
  "ServiceUrl": "https://www.jiyuwu.com"
}
```

##### ConfigHelper.cs
```
  public  class ConfigHelper
    {
        public static IConfiguration Configuration { get; set; }
        static ConfigHelper()
        {
            //ReloadOnChange = true 当appsettings.json被修改时重新加载
            Configuration = new ConfigurationBuilder()
            .Add(new JsonConfigurationSource { Path = "appsettings.json", ReloadOnChange = true })
            .Build();
        }

}
```

##### 创建MyDBContext
```
public class MyDBContext : DbContext
    {
        /// <summary>
        /// 配置连接字符串
        /// </summary>
        /// <param name="optionsBuilder"></param>
        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {
            base.OnConfiguring(optionsBuilder);
            optionsBuilder.UseSqlServer(ConfigHelper.GetSectionValue("TestConnection"));
        }
        public DbSet<Live_admin> Live_admins { get; set; }
    }
```
##### 创建实现Live_adminService
```
public async Task<List<Live_admin>> GetListAsync(string username,string password)
        {
            //using (MyDBContext db = new MyDBContext())
            //{
            //    var live_admin = (from e in db.Live_admins
            //                select e).ToList();
            //    return live_admin;
            //}
            using (MyDBContext db = new MyDBContext())
            {
                List<Live_admin> s = new List<Live_admin>();
                SqlParameter[] sqlparms = new SqlParameter[2];
                sqlparms[0] = new SqlParameter("@username", username);
                sqlparms[1] = new SqlParameter("@password", password);
                var result = await db.Database.ExecuteSqlCommandAsync("exec selectTable @ID,@name", sqlparms);
                var aaa=db.Database.sq
                foreach (var c in result)
                {
                    s.Add(new myTable { detail = c.detail, ID = c.ID, mes = c.mes, myTableID = c.myTableID, name = c.name });
                }
                return s;
            }
        }
```

评论区

先去登录

.net core 使用EF

相关推荐

评论区