SQL Artisan Database Access Component features overview

This article outlines SQL Artisan database access component functionality.

The existing version of SQL artisan is already in use in the project, and the results are quite ideal in the process of using it. Several new colleagues who have just contacted this component will soon be able to adapt to the project development process by understanding the examples already available. Component Object manipulation and compilation detection greatly improve the writing efficiency, The effect you get in your project is a bit unexpected.

SQL Artisang The next version of the feature Master is perfect for table object manipulation and object mapping; Includes: Table objects support data manipulation, object inheritance, view object mapping, statistical object mapping, and so on. In order to make the component function extend more convenient, the data mapping method of the component is reconstructed, The original XML description is changed to attribute, and the relevant mapping member is moved under the HFSoft.Data.Mapping namespace. The following description is just the functionality that the component has in the new version, and most of the implementation is still in progress.

Data manipulation of Table objects

The new Version Table object (table) is moved from the expressions name to the mapping namespace. The older version of the Table object only supports a single table-associated operation. The new, delete, modify, and query operations of the data are supported after the function is complete. In a program, you can define objects for tables and fields in the following ways:Table tbl = new Table("Employees");
NumberField field = new NumberField("EmployeeID");

Data NEW:Employees.TBL.Insert(
　　　　 Employees._FirstName.Set("Fan"),
　　　　 Employees._LastName.Set("Henry"),
　　　　 Employees._BirthDate.Set(DateTime.Parse("1979-1-1"))
　　　　 );

Data modification:Employees.TBL.Update(Employees._FirstName =="Fan",
　　　　 Employees._City.Set("GuangZhou"),
　　　　 Employees._Address.Set("TianHe"),
　　　　 Employees._Region.SetNull());