{"id":57962,"date":"2024-10-12T19:12:16","date_gmt":"2024-10-12T11:12:16","guid":{"rendered":"https:\/\/server.hk\/cnblog\/57962\/"},"modified":"2024-10-12T19:12:16","modified_gmt":"2024-10-12T11:12:16","slug":"net-core-%e6%95%b8%e6%93%9a%e5%ba%ab%e9%80%a3%e6%8e%a5%e7%b0%a1%e4%bb%8b-net-core-%e6%95%b8%e6%93%9a%e5%ba%ab%e9%80%a3%e6%8e%a5","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/57962\/","title":{"rendered":".NET Core \u6578\u64da\u5eab\u9023\u63a5\u7c21\u4ecb (.net core \u6578\u64da\u5eab\u9023\u63a5)"},"content":{"rendered":"

.NET Core \u6578\u64da\u5eab\u9023\u63a5\u7c21\u4ecb<\/h1>\n

.NET Core \u662f\u4e00\u500b\u8de8\u5e73\u53f0\u7684\u958b\u6e90\u6846\u67b6\uff0c\u5ee3\u6cdb\u7528\u65bc\u69cb\u5efa\u73fe\u4ee3\u5316\u7684\u61c9\u7528\u7a0b\u5f0f\u3002\u96a8\u8457\u6578\u64da\u9a45\u52d5\u61c9\u7528\u7a0b\u5f0f\u7684\u9700\u6c42\u4e0d\u65b7\u589e\u52a0\uff0c\u4e86\u89e3\u5982\u4f55\u5728 .NET Core \u4e2d\u9032\u884c\u6578\u64da\u5eab\u9023\u63a5\u8b8a\u5f97\u5c24\u70ba\u91cd\u8981\u3002\u672c\u6587\u5c07\u4ecb\u7d39 .NET Core \u7684\u6578\u64da\u5eab\u9023\u63a5\u65b9\u5f0f\uff0c\u5305\u62ec\u4f7f\u7528 Entity Framework Core \u548c ADO.NET \u7684\u57fa\u672c\u6982\u5ff5\u53ca\u793a\u4f8b\u3002<\/p>\n

1. .NET Core \u6578\u64da\u5eab\u9023\u63a5\u7684\u57fa\u672c\u6982\u5ff5<\/h2>\n

\u5728 .NET Core \u4e2d\uff0c\u6578\u64da\u5eab\u9023\u63a5\u4e3b\u8981\u4f9d\u8cf4\u65bc\u5169\u7a2e\u6280\u8853\uff1aEntity Framework Core \u548c ADO.NET\u3002\u9019\u5169\u8005\u5404\u6709\u512a\u7f3a\u9ede\uff0c\u958b\u767c\u8005\u53ef\u4ee5\u6839\u64da\u9700\u6c42\u9078\u64c7\u5408\u9069\u7684\u6280\u8853\u3002<\/p>\n

1.1 Entity Framework Core<\/h3>\n

Entity Framework Core\uff08EF Core\uff09\u662f\u4e00\u500b\u8f15\u91cf\u7d1a\u7684\u3001\u53ef\u64f4\u5c55\u7684 ORM\uff08\u5c0d\u8c61\u95dc\u4fc2\u6620\u5c04\uff09\u6846\u67b6\uff0c\u80fd\u5920\u7c21\u5316\u6578\u64da\u5eab\u64cd\u4f5c\u3002EF Core \u652f\u6301\u591a\u7a2e\u6578\u64da\u5eab\uff0c\u5305\u62ec SQL Server\u3001MySQL\u3001PostgreSQL \u7b49\u3002<\/p>\n

\u4f7f\u7528 EF Core \u9032\u884c\u6578\u64da\u5eab\u9023\u63a5\u7684\u6b65\u9a5f\uff1a<\/h4>\n
    \n
  1. \u5b89\u88dd EF Core \u5957\u4ef6\uff1a<\/li>\n
    dotnet add package Microsoft.EntityFrameworkCore.SqlServer<\/code><\/pre>\n
  2. \u5275\u5efa\u6578\u64da\u4e0a\u4e0b\u6587\u985e\uff1a<\/li>\n
    public class ApplicationDbContext : DbContext\n{\n    public ApplicationDbContext(DbContextOptions options) : base(options) { }\n\n    public DbSet<YourEntity> YourEntities { get; set; }\n}<\/code><\/pre>\n
  3. \u914d\u7f6e\u6578\u64da\u5eab\u9023\u63a5\u5b57\u7b26\u4e32\uff1a<\/li>\n
    services.AddDbContext<ApplicationDbContext>(options =>\n    options.UseSqlServer(Configuration.GetConnectionString(\"DefaultConnection\")))<\/code><\/pre>\n
  4. \u57f7\u884c\u6578\u64da\u9077\u79fb\uff1a<\/li>\n
    dotnet ef migrations add InitialCreate\ndotnet ef database update<\/code><\/pre>\n<\/ol>\n
    1.2 ADO.NET<\/h3>\n
    ADO.NET \u662f\u4e00\u500b\u66f4\u5e95\u5c64\u7684\u6578\u64da\u8a2a\u554f\u6280\u8853\uff0c\u63d0\u4f9b\u4e86\u5c0d\u6578\u64da\u5eab\u7684\u76f4\u63a5\u64cd\u4f5c\u3002\u5b83\u9069\u5408\u9700\u8981\u9ad8\u6027\u80fd\u548c\u7d30\u7c92\u5ea6\u63a7\u5236\u7684\u5834\u666f\u3002<\/p>\n
    \u4f7f\u7528 ADO.NET \u9032\u884c\u6578\u64da\u5eab\u9023\u63a5\u7684\u6b65\u9a5f\uff1a<\/h4>\n
      \n
    1. \u5275\u5efa\u6578\u64da\u5eab\u9023\u63a5\uff1a<\/li>\n
      using (SqlConnection connection = new SqlConnection(\"YourConnectionString\"))\n{\n    connection.Open();\n    \/\/ \u57f7\u884c\u6578\u64da\u5eab\u64cd\u4f5c\n}<\/code><\/pre>\n
    2. \u57f7\u884c SQL \u547d\u4ee4\uff1a<\/li>\n
      using (SqlCommand command = new SqlCommand(\"SELECT * FROM YourTable\", connection))\n{\n    using (SqlDataReader reader = command.ExecuteReader())\n    {\n        while (reader.Read())\n        {\n            \/\/ \u8655\u7406\u6578\u64da\n        }\n    }\n}<\/code><\/pre>\n<\/ol>\n
      2. \u6578\u64da\u5eab\u9023\u63a5\u7684\u6700\u4f73\u5be6\u8e10<\/h2>\n