.net Core学习笔记1 创建简单的 .net core项目

1.打开vs2017>Web

1：创建实体类：

namespace ProductMvc.Models
{

//商品类型
public class ProductType
{
public int ID { get; set; }
public string TypeName { get; set; }
public Product Product { get; set; }
}
}
namespace ProductMvc.Models
{

//商品
public class Product
{
public int ID { get; set; }
public string ProductName { get; set; }
public DateTime ProductDate { get; set; }
public decimal Price { get; set; }
 
public int TypeID { get; set; }
public ICollection<ProductType> ProductType;
}
}

2：创建数据库上下文

namespace ProductMvc.Models
{
public class ProductContext:DbContext
{
public ProductContext(DbContextOptions<ProductContext> options):base (options)
{
}
public DbSet<ProductType> ProductType { get; set; }
public DbSet<Product> Product { get; set; }
protected override void OnModelCreating(ModelBuilder modelBuilder)
{
modelBuilder.Entity<ProductType>().ToTable("ProductType");
modelBuilder.Entity<Product>().ToTable("Product");
}
}
}

3：打开Startup.cs文件，上下文依赖注入关系

public void ConfigureServices(IServiceCollection services)
{
 services.AddDbContext<SchoolContext>(options =>
options.UseSqlServer(Configuration.GetConnectionString("ProductConnection")));

services.AddMvc();
}

 

打开appsettings.json文件并添加连接字符串

{
"Logging": {
"IncludeScopes": false,
"LogLevel": {
"Default": "Warning"
}
},
"ConnectionStrings": {
"ProductConnection": "Server=(localdb)\mssqllocaldb;Database=DBProcuct;Trusted_Connection=True;MultipleActiveResultSets=true"
}
}

添加数据：添加类DbInitializer

 public class DbInitializer
{
public static void Initialize(ProductContext context)
{
context.Database.EnsureCreated();
if (context.Product.Any())
{
return;
}
var products = new Product[]
{
new Product{ProductName="牙膏",ProductDate=DateTime.Parse("2017-12-12"),Price=25,TypeID=1},
new Product{ProductName="毛巾",ProductDate=DateTime.Parse("2017-12-15"),Price=15,TypeID=1},
new Product{ProductName="电磁炉",ProductDate=DateTime.Parse("2017-12-12"),Price=25,TypeID=2},
new Product{ProductName="苹果",ProductDate=DateTime.Parse("2018-01-15"),Price=6,TypeID=3},
};
foreach (var item in products)
{
context.Product.Add(item);
}
context.SaveChanges();
var productType = new ProductType[]
{
new ProductType{ID=1,TypeName="百货类"},
new ProductType{ID=2,TypeName="电器类"},
new ProductType{ID=3,TypeName="水果类"},
};
foreach (var item in productType)
{
context.ProductType.Add(item);
}
context.SaveChanges();
}
}

在Program.cs，修改Main方法来执行以下操作，在应用程序启动：

using (var scope = BuildWebHost(args).Services.CreateScope())
{
var services = scope.ServiceProvider;
try
{
var context = services.GetRequiredService<ProductContext>();
DbInitializer.Initialize(context);
}
catch (Exception ex)
{
var logger = services.GetRequiredService<ILogger<Program>>();
logger.LogError(ex, "Have error!!!");
}
}
BuildWebHost(args).Run();

 

添加控制器和视图：视图带有EF的MVC控制器

以上操作即创建好了一个简单的 .net Core项目