{"rsdb":{"rid":"377544","subhead":"","postdate":"0","aid":"264186","fid":"106","uid":"1","topic":"1","content":"<div id=\"cnblogs_post_body\" class=\"blogpost-body \"> \n <div class=\"cnblogs_code\"> \n  <pre>\u3000<br \/>\u3000\u3000\/\/\u5b9e\u4f53\u7c7b<br \/>  [Table(<span style=\"color: #800000;\">&quot;<\/span><span style=\"color: #800000;\">invoiceinfo<\/span><span style=\"color: #800000;\">&quot;<\/span>, Schema = <span style=\"color: #800000;\">&quot;<\/span><span style=\"color: #800000;\">obs<\/span><span style=\"color: #800000;\">&quot;<\/span><span style=\"color: #000000;\">)]\r\n    <\/span><span style=\"color: #0000ff;\">public<\/span> <span style=\"color: #0000ff;\">class<\/span><span style=\"color: #000000;\"> invoice\r\n    {\r\n      \r\n        [Key]\r\n        <\/span><span style=\"color: #0000ff;\">public<\/span> <span style=\"color: #0000ff;\">string<\/span> invoice_num { <span style=\"color: #0000ff;\">get<\/span>; <span style=\"color: #0000ff;\">set<\/span><span style=\"color: #000000;\">; }\r\n\r\n        <\/span><span style=\"color: #0000ff;\">public<\/span> <span style=\"color: #0000ff;\">string<\/span> merchant_id { <span style=\"color: #0000ff;\">get<\/span>; <span style=\"color: #0000ff;\">set<\/span><span style=\"color: #000000;\">; }\r\n\r\n        <\/span><span style=\"color: #0000ff;\">public<\/span> DateTimeOffset? verify_time { <span style=\"color: #0000ff;\">get<\/span>; <span style=\"color: #0000ff;\">set<\/span><span style=\"color: #000000;\">; }\r\n\r\n        \/\/one to many<br \/>       <\/span><span style=\"color: #0000ff;\">public<\/span> <span style=\"color: #0000ff;\">virtual<\/span> IList&lt;invoice_relation&gt; invoice_file_list { <span style=\"color: #0000ff;\">get<\/span>; <span style=\"color: #0000ff;\">set<\/span><span style=\"color: #000000;\">; }\r\n\r\n     \u3000\u3000\/\/one to one\r\n        <\/span><span style=\"color: #0000ff;\">public<\/span> <span style=\"color: #0000ff;\">virtual<\/span> business invoice_business { <span style=\"color: #0000ff;\">get<\/span>; <span style=\"color: #0000ff;\">set<\/span><span style=\"color: #000000;\">; }\r\n\r\n      \r\n    }<\/span><\/pre> \n <\/div> \n <div class=\"cnblogs_code\"> \n  <pre>\/\/\u6570\u636e\u5e93  PostgreDbContext\u76f8\u5173\u914d\u7f6e<br \/><br \/><span style=\"color: #0000ff;\">protected<\/span> <span style=\"color: #0000ff;\">override<\/span> <span style=\"color: #0000ff;\">void<\/span><span style=\"color: #000000;\"> OnModelCreating(ModelBuilder builder)\r\n        {\r\n            <\/span><span style=\"color: #0000ff;\">base<\/span><span style=\"color: #000000;\">.OnModelCreating(builder);\r\n            builder.Entity<\/span>&lt;invoice&gt;().HasMany(i =&gt; i.invoice_file_list).WithOne().HasForeignKey(f =&gt;<span style=\"color: #000000;\"> f.invoice_num);\r\n            builder.Entity<\/span>&lt;invoice&gt;().HasOne(i =&gt; i.invoice_business).WithMany().HasForeignKey(i =&gt;<span style=\"color: #000000;\"> i.merchant_id);\r\n        }<\/span><\/pre> \n <\/div> \n <div class=\"cnblogs_code\"> \n  <pre> \/\/.file\u4e3ainvoice_file_list\u7c7b\u4e2d\u5b57\u6bb5\u5c5e\u6027\uff0c.invoiced_party\u4e3ainvoice_business\u5b57\u6bb5\u5c5e\u6027<br \/> IQueryable&lt;invoice&gt; invoiceList = _postgreDbContext.invoice.AsNoTracking().Include(<span style=\"color: #800000;\">&quot;<\/span><span style=\"color: #800000;\">invoice_file_list.file<\/span><span style=\"color: #800000;\">&quot;<\/span>).Include(<span style=\"color: #800000;\">&quot;<\/span><span style=\"color: #800000;\">invoice_business.invoiced_party<\/span><span style=\"color: #800000;\">&quot;<\/span>);<\/pre> \n <\/div> \n <p>&nbsp;<\/p> \n<\/div>","orderid":"0","title":".netcore2.1 ef \u4f7f\u7528\u5916\u952e\u5173\u8054\u67e5\u8be2","smalltitle":"","mid":"0","fname":".NET","special_id":"0","bak_id":"0","info":"0","hits":"313","pages":"1","comments":"0","posttime":"2019-10-10 18:14:55","list":"1570702495","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"<A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=.netcore2.1' target=_blank>.netcore2.1<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%CA%B9%D3%C3' target=_blank>\u4f7f\u7528<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B9%D8%C1%AA' target=_blank>\u5173\u8054<\/A> <A HREF='https:\/\/www.cppentry.com\/do\/search.php?type=keyword&keyword=%B2%E9%D1%AF' target=_blank>\u67e5\u8be2<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"14.17.22.37","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":".netcore2.1 ef \u4f7f\u7528\u5916\u952e\u5173\u8054\u67e5\u8be2","lastview":"1715047213","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}