Public Instance Constructors
Public Instance Properties
| Author (inherited from General) |
The author, is used when generating the header.
|
| Comment (inherited from General) |
Comment is used when generating the header.
|
| Company (inherited from General) |
Company.
|
| ConnectionString (inherited from General) |
Connectionstring
|
| CurrentOperation (inherited from General) |
Current operation such as: Insert, Update, Delete, SelAll, SelUni
|
| DoGenerateDropScript |
Should the stored procedure include drop script
|
| DoGenerateHeader |
Should the stored procedure include a header
|
| DoReturnIdentityValue (inherited from General) | |
| EntityObject (inherited from General) |
The name of the table.
|
| IsNullDefault |
Set default value for parameter to null.
|
| StoredProcedureName (inherited from General) |
The name of the stored procedure. Removes any prefix on the table and adds the prefix 'p'.
|
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 Properties
| connection (inherited from General) |
SqlConnection
|
| TableInformation (inherited from General) |
Contains the information about the column names, primary keys and datatypes.
|
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