摘要:using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Xml.Serialization; using System.Xml; namespace DuFul
阅读全文
摘要:sql: create view ViewEmployeeMasters as select a.*,b.Name as 'DepartmentName',b.Code as 'DepartmentCode' from EmployeeMasters as a,DepartmentMaster as
阅读全文
摘要:/* function mappinghttps://learn.microsoft.com/en-us/ef/core/querying/user-defined-function-mapping view mapping public DbQuery<View_BookDetails> View
阅读全文
摘要:sql: IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].People') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE People GO CREATE
阅读全文
摘要:sql: IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].DepartmentMaster') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE Depart
阅读全文
摘要:sql: IF EXISTS (select * from sysobjects where id = object_id(N'[dbo].GeovinDuMap') and OBJECTPROPERTY(id, N'IsUserTable') = 1) DROP TABLE GeovinDuMap
阅读全文
摘要:[Keyless] public class PersonOrderCount { public string Name { get; set; } public int Count { get; set; } } public class Person { public int PersonId
阅读全文
摘要:初始化创建表和数据 /// <summary> /// ///Entity /// </summary> public class Product { public Product() { } public int Id { get; set; } public string Name { get;
阅读全文