nuget
A generic abstract model of a SQL table.
SQLTable
00 Remarks
(SQL之中的一个数据表的抽象描述接口)
01 Syntax
Microsoft.VisualBasic.ComponentModel.DataSourceModel.SchemaMaps.SQLTable
02 Methods
| Name | Overloads | Summary |
|---|---|---|
| GetInsertSQL | 1 | INSERT INTO table_name (field1, field2,...) VALUES (value1, value2,....) |
| GetUpdateSQL | 1 | UPDATE table_name SET field = <new value> WHERE field = <value |
| GetDeleteSQL | 1 | DELETE FROM table_name WHERE field = value; |
| ToString | 1 | Display the INSERT INTO sql from function SQLTable.GetInsertSQL(). |
| Clone | 1 | Clones the property values. |
| Copy | 1 | MemberwiseClone |
03 Members
GetInsertSQL
INSERT INTO table_name (field1, field2,...) VALUES (value1, value2,....)
Remarks
GetUpdateSQL
UPDATE table_name SET field = <new value> WHERE field = <value>
Remarks
GetDeleteSQL
DELETE FROM table_name WHERE field = value;
ToString
Display the INSERT INTO sql from function SQLTable.GetInsertSQL().
Clone
Clones the property values.
Remarks
(由于这个SQLTable对象的所有属性都是简单的基本类型，所以能够很容易 的复制这些属性，从而很容易的复制数据表之中的一个行对象)
Copy
MemberwiseClone