Entity Framework 系列
最近會忘記一些移轉的命令，在這邊先記錄一下，資料移轉的指令
在專案底下先裝
1.EntityFramework 6.x
2.EntityFramework.SqlServer 6.x
在AppConfig設定好DB路徑
<add name="KTStoreModelConn" connectionString="Data Source=localhost;Initial Catalog=KTStore;Integrated Security=True" providerName="System.Data.SqlClient" />
開始定義測試類別
namespace EFDemo.Model
{
public class Category
{
public int Id { get; set; }
public string Name { get; set; }
public ICollection<Product> Product { get; set; }
}
}
public class Product
{
public int Id { get; set; }
public string Name { get; set; }
public int Price { get; set; }
public int Category_Id { get; set; }
[ForeignKey("Category_Id")]
public virtual Category Category { get; set; }
}
定義DbContext部分
public class KTStoreModel:DbContext
{
public KTStoreModel() : base("name=KTStoreModelConn")
{
}
protected override void OnModelCreating(DbModelBuilder modelBuilder)
{
}
public DbSet<Product> Products { get; set; }
public DbSet<Category> Categorys { get; set; }
}
開始移轉指令
Enable-Migrations
開始塞一些假資料進去測試
namespace EFDemo.Migrations
{
using System;
using System.Data.Entity;
using System.Data.Entity.Migrations;
using System.Linq;
internal sealed class Configuration : DbMigrationsConfiguration<EFDemo.Model.KTStoreModel>
{
public Configuration()
{
AutomaticMigrationsEnabled = false;
}
protected override void Seed(EFDemo.Model.KTStoreModel context)
{
// This method will be called after migrating to the latest version.
// You can use the DbSet<T>.AddOrUpdate() helper extension method
// to avoid creating duplicate seed data. E.g.
//
// context.People.AddOrUpdate(
// p => p.FullName,
// new Person { FullName = "Andrew Peters" },
// new Person { FullName = "Brice Lambson" },
// new Person { FullName = "Rowan Miller" }
// );
//
context.Products.Add(new Product { Name = "ASP.NET MVC 商業應用開發實務", Price = 850, Category_Id = 1 });
context.Products.Add(new Product { Name = "Entity Framework 實務精要", Price = 800, Category_Id = 1 });
context.Products.Add(new Product { Name = "HTML 5從零開始", Price = 550, Category_Id = 1 });
context.Products.Add(new Product { Name = "HTML 5完美風暴", Price = 1000, Category_Id = 1 });
context.Products.Add(new Product { Name = "Entity Framework 與 LINQ 開發實戰", Price = 590, Category_Id = 1 });
context.Products.Add(new Product { Name = "ASP.net 商業級資料庫網站開發實務", Price = 650, Category_Id = 1 });
context.Products.Add(new Product { Name = "Visual C#精要剖析", Price = 520, Category_Id = 1 });
context.Products.Add(new Product { Name = "3U工業用機殼", Price = 4000, Category_Id = 2 });
context.Products.Add(new Product { Name = "CUP散熱器 MITX", Price = 950, Category_Id = 2 });
context.Products.Add(new Product { Name = "四熱管多合一CPU風扇", Price = 980, Category_Id = 2 });
context.Products.Add(new Product { Name = "PC RS 232 擴充卡", Price = 1020, Category_Id = 2 });
context.Products.Add(new Product { Name = "ASUC 變壓器 ", Price = 3600, Category_Id = 2 });
context.Products.Add(new Product { Name = "8 PORT USB充電器", Price = 1620, Category_Id = 2 });
context.Products.Add(new Product { Name = "8 PORT USB充電器", Price = 1620, Category_Id = 2 });
context.Products.Add(new Product { Name = "鋁殼2400米傳輸線", Price = 2500, Category_Id = 3 });
context.Products.Add(new Product { Name = "行動電源超薄型 85000mAh", Price = 500, Category_Id = 3 });
context.Products.Add(new Product { Name = "行動電源USB離子電芯", Price = 1800, Category_Id = 3 });
context.Products.Add(new Product { Name = "手機Shap離電池", Price = 1600, Category_Id = 3 });
context.Products.Add(new Product { Name = "AC轉USB充電器", Price = 280, Category_Id = 3 });
context.Products.Add(new Product { Name = "USB復古4吋風扇", Price = 850, Category_Id = 4 });
context.Products.Add(new Product { Name = "LED燈 B-LED ", Price = 250, Category_Id = 4 });
context.Products.Add(new Product { Name = "USB 3.0 共享傳輸線", Price = 1500, Category_Id = 4 });
context.Products.Add(new Product { Name = "USB 3.0 18 HUB", Price = 1450, Category_Id = 4 });
context.Products.Add(new Product { Name = "7 Port USB充電器", Price = 2250, Category_Id = 4 });
context.Categorys.Add(new Category { Id = 1, Name = "Book" });
context.Categorys.Add(new Category { Id = 2, Name = "PC" });
context.Categorys.Add(new Category { Id = 3, Name = "Mobile" });
context.Categorys.Add(new Category { Id = 4, Name = "USB" });
context.SaveChanges();
}
}
}
Add-Migration InitCreateTableData
update-Database
移轉完成。
如果有要變動欄位呢???
Add-Migration AddCategory_testqty
Update-Database
這樣在就會進行資料變更移轉了
老E隨手寫