172 lines
5.5 KiB
Plaintext
172 lines
5.5 KiB
Plaintext
{
|
|
"cells": [
|
|
{
|
|
"attachments": {},
|
|
"cell_type": "markdown",
|
|
"metadata": {},
|
|
"source": [
|
|
"EFCore7 学习与总结 \n",
|
|
"================="
|
|
]
|
|
},
|
|
{
|
|
"attachments": {},
|
|
"cell_type": "markdown",
|
|
"metadata": {},
|
|
"source": [
|
|
"## 全局设置"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 1,
|
|
"metadata": {
|
|
"dotnet_interactive": {
|
|
"language": "csharp"
|
|
},
|
|
"polyglot_notebook": {
|
|
"kernelName": "csharp"
|
|
},
|
|
"vscode": {
|
|
"languageId": "polyglot-notebook"
|
|
}
|
|
},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/html": [
|
|
"<div><div><strong>Restore sources</strong><ul><li><span>https://api.nuget.org/v3/index.json</span></li></ul></div><div></div><div><strong>Installed Packages</strong><ul><li><span>Microsoft.EntityFrameworkCore, 7.0.5</span></li><li><span>Microsoft.EntityFrameworkCore.InMemory, 7.0.5</span></li><li><span>Microsoft.EntityFrameworkCore.Sqlite, 7.0.5</span></li><li><span>Microsoft.EntityFrameworkCore.SqlServer, 7.0.5</span></li></ul></div></div>"
|
|
]
|
|
},
|
|
"metadata": {},
|
|
"output_type": "display_data"
|
|
}
|
|
],
|
|
"source": [
|
|
"//设置包源\n",
|
|
"#i \"https://api.nuget.org/v3/index.json\"\n",
|
|
"\n",
|
|
"//引用包\n",
|
|
"#r \"nuget: Microsoft.EntityFrameworkCore\"\n",
|
|
"#r \"nuget: Microsoft.EntityFrameworkCore.SqlServer,7.0.5\"\n",
|
|
"#r \"nuget: Microsoft.EntityFrameworkCore.InMemory\"\n",
|
|
"#r \"nuget: Microsoft.EntityFrameworkCore.Sqlite\""
|
|
]
|
|
},
|
|
{
|
|
"attachments": {},
|
|
"cell_type": "markdown",
|
|
"metadata": {},
|
|
"source": [
|
|
"## DbContext"
|
|
]
|
|
},
|
|
{
|
|
"cell_type": "code",
|
|
"execution_count": 5,
|
|
"metadata": {
|
|
"dotnet_interactive": {
|
|
"language": "csharp"
|
|
},
|
|
"polyglot_notebook": {
|
|
"kernelName": "csharp"
|
|
},
|
|
"vscode": {
|
|
"languageId": "polyglot-notebook"
|
|
}
|
|
},
|
|
"outputs": [
|
|
{
|
|
"data": {
|
|
"text/html": [
|
|
"<table><thead><tr><th><i>index</i></th><th>value</th></tr></thead><tbody><tr><td>0</td><td><details class=\"dni-treeview\"><summary><span class=\"dni-code-hint\"><code>Submission#6+Account</code></span></summary><div><table><thead><tr></tr></thead><tbody><tr><td>Id</td><td><div class=\"dni-plaintext\"><pre>1</pre></div></td></tr><tr><td>Code</td><td>001</td></tr><tr><td>Name</td><td>zhangsan</td></tr><tr><td>Pwd</td><td>123456</td></tr><tr><td>Age</td><td><div class=\"dni-plaintext\"><pre>25</pre></div></td></tr><tr><td>State</td><td><div class=\"dni-plaintext\"><pre>0</pre></div></td></tr></tbody></table></div></details></td></tr><tr><td>1</td><td><details class=\"dni-treeview\"><summary><span class=\"dni-code-hint\"><code>Submission#6+Account</code></span></summary><div><table><thead><tr></tr></thead><tbody><tr><td>Id</td><td><div class=\"dni-plaintext\"><pre>2</pre></div></td></tr><tr><td>Code</td><td>002</td></tr><tr><td>Name</td><td>lisi</td></tr><tr><td>Pwd</td><td>123456</td></tr><tr><td>Age</td><td><div class=\"dni-plaintext\"><pre>35</pre></div></td></tr><tr><td>State</td><td><div class=\"dni-plaintext\"><pre>0</pre></div></td></tr></tbody></table></div></details></td></tr></tbody></table><style>\r\n",
|
|
".dni-code-hint {\r\n",
|
|
" font-style: italic;\r\n",
|
|
" overflow: hidden;\r\n",
|
|
" white-space: nowrap;\r\n",
|
|
"}\r\n",
|
|
".dni-treeview {\r\n",
|
|
" white-space: nowrap;\r\n",
|
|
"}\r\n",
|
|
".dni-treeview td {\r\n",
|
|
" vertical-align: top;\r\n",
|
|
" text-align: start;\r\n",
|
|
"}\r\n",
|
|
"details.dni-treeview {\r\n",
|
|
" padding-left: 1em;\r\n",
|
|
"}\r\n",
|
|
"table td {\r\n",
|
|
" text-align: start;\r\n",
|
|
"}\r\n",
|
|
"table tr { \r\n",
|
|
" vertical-align: top; \r\n",
|
|
" margin: 0em 0px;\r\n",
|
|
"}\r\n",
|
|
"table tr td pre \r\n",
|
|
"{ \r\n",
|
|
" vertical-align: top !important; \r\n",
|
|
" margin: 0em 0px !important;\r\n",
|
|
"} \r\n",
|
|
"table th {\r\n",
|
|
" text-align: start;\r\n",
|
|
"}\r\n",
|
|
"</style>"
|
|
]
|
|
},
|
|
"metadata": {},
|
|
"output_type": "display_data"
|
|
}
|
|
],
|
|
"source": [
|
|
"using Microsoft.EntityFrameworkCore;\n",
|
|
"using Microsoft.EntityFrameworkCore.SqlServer;\n",
|
|
"public class AppDbContext: DbContext\n",
|
|
"{\n",
|
|
" public DbSet<Account> Accounts {get;set;}\n",
|
|
"\n",
|
|
" protected override void OnConfiguring(DbContextOptionsBuilder builder)\n",
|
|
" {\n",
|
|
" builder\n",
|
|
" .UseSqlServer(@\"Server=127.0.0.1\\SQL2019;Database=EFCore7Study;User Id=sa;Password=gly-bicijinlian;Encrypt=True;TrustServerCertificate=True;\")\n",
|
|
" .EnableSensitiveDataLogging();\n",
|
|
" }\n",
|
|
"\n",
|
|
" protected override void OnModelCreating(ModelBuilder builder)\n",
|
|
" {\n",
|
|
" builder.Entity<Account>().ToTable(\"Account\");\n",
|
|
" base.OnModelCreating(builder);\n",
|
|
" }\n",
|
|
"}\n",
|
|
"\n",
|
|
"public class Account\n",
|
|
"{\n",
|
|
" public int Id { get; set; }\n",
|
|
" public string Code { get; set; }\n",
|
|
" public string Name { get; set; }\n",
|
|
" public string Pwd { get; set; }\n",
|
|
"\n",
|
|
" public int Age { get; set; }\n",
|
|
"\n",
|
|
" public int State { get; set; } \n",
|
|
"}\n",
|
|
"\n",
|
|
"using(var db = new AppDbContext())\n",
|
|
"{\n",
|
|
" var itmes = db.Accounts.ToList();\n",
|
|
"\n",
|
|
" itmes.Display();\n",
|
|
"\n",
|
|
"}"
|
|
]
|
|
}
|
|
],
|
|
"metadata": {
|
|
"language_info": {
|
|
"name": "python"
|
|
},
|
|
"orig_nbformat": 4
|
|
},
|
|
"nbformat": 4,
|
|
"nbformat_minor": 2
|
|
}
|