StoredProcedureModelCommon
You can find the object model in the StoredProcedureModelCommon project of the FullProject solution (or in Models/ StoredProcedureModelCommon under the trunk).
The current implementation of StoredProcedureModelCommon interfaces is SpInputMetadataWrapper found in the FullProject solution (or in Wrappers/SpInputMetadataWrapper under the trunk)
The stored procedure model represents metadata from the perspective of writing stored procedures. To use this model:
- Create a stored procedure template using the suggested pattern
- Reference this project
- Import GenDotNet.StoredProcedureModel (part of the pattern sample)
At this point you’ll have an IEntityData reference available in the EntityData class variable and should see Intellisense on the following structure:
- EntityData (IEntityData)
- Name (String)
- DoGenerateCreate (Boolean)
- DoGenerateRetrieve (Boolean)
- DoGenerateUpdate (Boolean)
- DoGenerateDelete (Boolean)
- DoGenerateSetSelect (Boolean)
- Children (IEnumerable(IChildData))
- UniqueName (String)
- ChildEntity (IEntityData)
- ParentEntity (IEntityData)
- ChildKeys (IEnumerable(IRelationKey))
- ParentColumnName (String)
- ParentAlias (String)
- ChildColumnName (String)
- ChildAlias (String)
- ParentTable (ITableData)
- Schema (String)
- Name (String)
- ChildTable (ITableData)
- Recordset (IRecordset)
- Name (String)
- MainTable (ITableData)
- InsertPriority (Int32)
- ChildFlag (IUInt32)
- IsDistinct (Boolean)
- Columns (IEnumerable(IColumnData))
- Name (String)
- Caption (String)
- Ordinal (String)
- SqlType (String)
- IsPimaryKey (Boolean)
- Is AutoIncrement (Boolean)
- AllowNulls (Boolean)
- MaxLength (Int32)
- Precision (Int32)
- Scale (Int32)
- ColumnAlias (String)
- Table (ITableData)
- IsReadOnly (Boolean)
- Joins (IEnumerable(IJoinData))
- JoinType (JoinType)
- JoinStyle (JoinStyle)
- ParentTable (ITableData)
- ChildTable (ITableData)
- ChildAlias (String)
- JoinKeys (IEnumerable(IRelationKey))
- OrderBies (IEnumerable(IOrderBy))
- Direction (OrderByDirection)
- Column (IColumnData)
- InsertColumns (IEnumerable(IColumnData))
- UpdateColumns (IEnumerable(IColumnData))
- PrimaryKeyColumns (IEnumerable(IColumnData))
- SetRecordset (IRecorset)