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)

Last edited Mar 29, 2008 at 9:35 PM by KathleenDollard, version 12

Comments

No comments yet.