上一页 1 ··· 38 39 40 41 42 43 44 45 46 ··· 119 下一页
摘要: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Xml.Serialization; using System.Xml; namespace DuFul 阅读全文
posted @ 2023-02-11 09:49 ®Geovin Du Dream Park™ 阅读(28) 评论(0) 推荐(0)
摘要: /// <summary> /// https://learn.microsoft.com/zh-cn/ef/core/logging-events-diagnostics/simple-logging /// </summary> /// <param name="optionsBuilder"> 阅读全文
posted @ 2023-02-08 23:14 ®Geovin Du Dream Park™ 阅读(30) 评论(0) 推荐(0)
摘要: sql: create view ViewEmployeeMasters as select a.*,b.Name as 'DepartmentName',b.Code as 'DepartmentCode' from EmployeeMasters as a,DepartmentMaster as 阅读全文
posted @ 2023-02-07 22:35 ®Geovin Du Dream Park™ 阅读(63) 评论(0) 推荐(0)
摘要: /* function mappinghttps://learn.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping view mapping public DbQuery<View_BookDetails> View 阅读全文
posted @ 2023-02-07 16:44 ®Geovin Du Dream Park™ 阅读(44) 评论(0) 推荐(0)
摘要: sql: IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].People') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE People GO CREATE 阅读全文
posted @ 2023-02-06 23:40 ®Geovin Du Dream Park™ 阅读(66) 评论(0) 推荐(0)
摘要: sql: IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].DepartmentMaster') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE Depart 阅读全文
posted @ 2023-02-06 17:22 ®Geovin Du Dream Park™ 阅读(25) 评论(0) 推荐(0)
摘要: sql: IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].GeovinDuMap') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE GeovinDuMap 阅读全文
posted @ 2023-02-05 23:07 ®Geovin Du Dream Park™ 阅读(20) 评论(0) 推荐(0)
摘要: [Keyless] public class PersonOrderCount { public string Name { get; set; } public int Count { get; set; } } public class Person { public int PersonId 阅读全文
posted @ 2023-02-04 19:46 ®Geovin Du Dream Park™ 阅读(40) 评论(0) 推荐(0)
摘要: 初始化创建表和数据 /// <summary> /// ///Entity /// </summary> public class Product { public Product() { } public int Id { get; set; } public string Name { get; 阅读全文
posted @ 2023-02-04 12:24 ®Geovin Du Dream Park™ 阅读(48) 评论(0) 推荐(0)
摘要: sql script --dbo.Students --Id int identity --Name --Age byte --CreatedTime date -- ModifiedTime date IF EXISTS (select * from sysobjects where id = o 阅读全文
posted @ 2023-01-29 11:40 ®Geovin Du Dream Park™ 阅读(35) 评论(0) 推荐(0)
上一页 1 ··· 38 39 40 41 42 43 44 45 46 ··· 119 下一页