The methods of the Sp class are listed below. For a complete list of Sp class members, see the Sp Members topic.
Public Instance Methods
| DeleteSp |
Generates the sp delete code.
|
| Equals (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| GetHashCode (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| GetType (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| InsertSp |
Generates the sp insert code.
|
| SelAllSp |
Generates the sp insert code.
|
| SelUniSp |
Generates the sp sel uni code.
|
| ToString (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| UpdateSp |
Generates the sp update code.
|
Protected Instance Methods
| Finalize (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| GetTableInformation (inherited from General) |
Fills three tables with info about the columns, primary keys, columns datatypes for a specified table.
Tables, index- 0 - colums, using sp_Columns
- 1 - datatypes, using sp_datatype_info
- 2 - Primary key(s), using sp_keys
|
| MemberwiseClone (inherited from Object) | Select the method name to go to the Microsoft documentation. |
| RemoveIdentityString (inherited from General) |
Removes the suffix 'identity' from the parameter.
|
| RemoveTablePrefix (inherited from General) |
Removes table prefix 't'.
|
| UpdateTableInformation (inherited from General) |
Check if system should load information about a new table.
|
See Also
Sp Class | Magnusson.Data.SqlAutomation Namespace