


Detailed introduction to C# reflection and feature checking
Reflection and Properties
The reflection and feature technologies provided by .net framework can be used to check data repeatability to decide whether to write a certain piece of data to the database table.
Requirements
When an entity writes a piece of data to the database, many times it is necessary to check whether the data is a duplicate, such as a new person, assuming The ID number cannot be repeated. If the newly created personnel ID number is duplicated with one or more entries in the personnel table, a prompt or other means need to be given, such as updating or deleting.
Method
In this demand scenario, you can use the features and reflection technology provided by .net framework to solve such needs. The specific process,
Secondly, reference the newly written feature class in the entity class to construct its unique identifier (one or more attribute combinations);
Finally, When checking data repeatability, use the method provided by Attribute to obtain the unique identification attribute (one or more) of each entity class.
Attribute[] GetCustomAttributes(modeltype, inherit);
public class KeyFieldAttribute:Attribute
{ private static List<string> keyfields = new List<string>();
/// <summary>
/// 构造关键属性
/// </summary>
/// <param name="fields"></param>
public KeyFieldAttribute(params string[] fields)
{ foreach (string kf in fields)
{ if (!keyfields.Contains(kf))
keyfields.Add(kf);
}
} public static List<string> KeyFields
{ get { return keyfields; }
}
}
Copy after login
Entity class Model public class KeyFieldAttribute:Attribute { private static List<string> keyfields = new List<string>(); /// <summary> /// 构造关键属性 /// </summary> /// <param name="fields"></param> public KeyFieldAttribute(params string[] fields) { foreach (string kf in fields) { if (!keyfields.Contains(kf)) keyfields.Add(kf); } } public static List<string> KeyFields { get { return keyfields; } } }
[KeyField("ID")]public class Person
{ public int ID {get;set;} //人员ID
public string Name {get;set;}//人员名称
public DateTime BirthDate {get;set;} //出生年月日}
[KeyField("RoleGroupID","RoleCode")] public class Role
{ public int RoleGroupID { get; set; } //角色组别ID
public string RoleCode { get; set; } //角色编号
public string RoleName { get; set; }//角色名称
}
Copy after login
Pay attention to the attribute extension class. Here, the suffix Attribute in KeyFieldAttribute can be omitted, so KeyField is an abbreviation, equivalent to KeyFieldAttribute. Use feature class: [KeyField("ID")]public class Person { public int ID {get;set;} //人员ID public string Name {get;set;}//人员名称 public DateTime BirthDate {get;set;} //出生年月日} [KeyField("RoleGroupID","RoleCode")] public class Role { public int RoleGroupID { get; set; } //角色组别ID public string RoleCode { get; set; } //角色编号 public string RoleName { get; set; }//角色名称 }
KeyFieldAttribute.GetCustomAttributes(typeof(Person), true);
List<string> fields = KeyFieldAttribute.KeyFields; //获取到Person实体的唯一标识属性ID
KeyFieldAttribute.GetCustomAttributes(typeof(Role), true);
var fields = KeyFieldAttribute.KeyFields;//Role实体唯一属性,2个属性组合:RoleGroupID,RoleCode
Copy after login
Use the key attribute combination returned by the feature to query the data in the database. If at least one record can be found, it will be processed according to certain logic; if not, then New data can be written directly. Method description provided in the Attribute class: KeyFieldAttribute.GetCustomAttributes(typeof(Person), true); List<string> fields = KeyFieldAttribute.KeyFields; //获取到Person实体的唯一标识属性ID KeyFieldAttribute.GetCustomAttributes(typeof(Role), true); var fields = KeyFieldAttribute.KeyFields;//Role实体唯一属性,2个属性组合:RoleGroupID,RoleCode
/// <summary>/// 检索应用于类型的成员的自定义特性的数组。 /// </summary>/// <param name="modeltype">要搜索的自定义特性的类型</param> ///<param name="inherit">是否搜索成员的祖先</param> /// <returns>自定义特性的数组</returns>Attribute[] GetCustomAttributes(modeltype, inherit);

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



Guide to Active Directory with C#. Here we discuss the introduction and how Active Directory works in C# along with the syntax and example.

Guide to Random Number Generator in C#. Here we discuss how Random Number Generator work, concept of pseudo-random and secure numbers.

Guide to C# Serialization. Here we discuss the introduction, steps of C# serialization object, working, and example respectively.

Guide to C# Data Grid View. Here we discuss the examples of how a data grid view can be loaded and exported from the SQL database or an excel file.

Guide to Patterns in C#. Here we discuss the introduction and top 3 types of Patterns in C# along with its examples and code implementation.

Guide to Prime Numbers in C#. Here we discuss the introduction and examples of prime numbers in c# along with code implementation.

Guide to Factorial in C#. Here we discuss the introduction to factorial in c# along with different examples and code implementation.

The difference between multithreading and asynchronous is that multithreading executes multiple threads at the same time, while asynchronously performs operations without blocking the current thread. Multithreading is used for compute-intensive tasks, while asynchronously is used for user interaction. The advantage of multi-threading is to improve computing performance, while the advantage of asynchronous is to not block UI threads. Choosing multithreading or asynchronous depends on the nature of the task: Computation-intensive tasks use multithreading, tasks that interact with external resources and need to keep UI responsiveness use asynchronous.
