Missing tables and procedures for .NET - 1.0

Compatibility: v2 v3 Express
What's new? Release Notes
ID: com.castsoftware.dotnet.missingtable

Description

This extension is designed to analyze SQL queries embedded in .NET code / ORM CRUD objects aka Entity Operations and create “missing” SQL and DotNet table / procedure objects to represent SQL objects that have not been delivered for analysis. Links to these objects are also created. The primary goal of the extension is to ensure that a full transaction is identified by CAST, resulting from the SQL queries embedded in the .NET code / ORM CRUD objects, even if none or only part of the referenced SQL objects are delivered for analysis.

Supported client languages

Language Supported?
.NET ✅

Transactions

Transaction support is derived from metamodel concepts used to build CAST Imaging Blueprint and structural transaction flows. Entry Points start transactions; Exit Points include both output/boundary concepts and Data Entities manipulated by transactions.

Role Support Breakdown
Entry Point No direct concept type details
Exit Point
  • Procedure
Data Entity with Accurate FP
  • Table
Data Entities
  • SQL Table - Unresolved

Data version: 1.0.8-funcrel

ISO 5055 Structural Rules

Quality support is based on ISO 5055 structural rules available for the selected extension version.

Reliability Maintainability Security Performance Efficiency

Data version: 1.0.8-funcrel

Prerequisites

Item Description
✅ An installation of any compatible release of CAST Core (see table above)
✅ An installation of com.castsoftware.sqlanalyzer (from version ≥ 3.6.9-funcrel). Embedded tables were introduced in version 3.8.0-funcrel and system table in 3.8.1-funcrel.

Download and installation instructions

The extension will be automatically downloaded and installed in CAST Console when .NET source code is delivered for analysis. You can manage it using the Application - Extensions interface.

What results can you expect?

Objects

Icon Object Type Description Metamodel Type
Missing Schema Parent of the missing tables and procedures, attached to the .NET Project. CAST_DotNet_MissingTable_Schema
Missing Table A table or a view selected/updated/deleted/inserted in a .NET Query / ORM CRUD object missing from the DDL file. CAST_DotNet_MissingTable_Table
Missing Procedure A procedure or a function called in a .NET Query missing from the DDL file. CAST_DotNet_MissingTable_Procedure
SQL Missing Table A table or a view selected/updated/deleted/inserted in a .NET Query / ORM CRUD object missing from the DDL file, but we have a SQL Schema, and only one. SQLScript_Missing_Table
SQL Missing Procedure A procedure or a function called in a .NET Query missing from the DDL file but we have a SQL Schema, and only one. SQLScript_Missing_Procedure
Embedded Schema Parent of the embedded tables, attached to the .NET Project. CAST_DotNet_EmbeddedTable_Schema
Embedded Table A table created/dropped/altered/replaced/renamed/declared in a .NET Query missing from the DDL file. CAST_DotNet_EmbeddedTable_Table
System Schema Parent of the system tables, attached to the .NET Project. CAST_DotNet_SystemTable_Schema
System Table A system table or a system view selected/updated/deleted/inserted in a .NET Query / ORM CRUD objet missing from the DDL file. CAST_DotNet_SystemTable_Table
SQL System Table A system table or a system view selected/updated/deleted/inserted in a .NET Query / ORM CRUD object missing from the DDL file, but we have a SQL Schema, and only one. SQLScript_System_Table

Links are created for transaction and function point needs. You can expect the following links on the .NET Embedded SQL queries / ORM CRUD objects:

  • useSelect/useUpdate/useDelete/useInsert from .NET Query / ORM CRUD object to Embedded Table / Missing Table / System Table / SQL Missing Table / SQL System Table
  • call from .NET Query to Missing Procedure/SQL Missing Procedure
  • ddl/ddlCreate/ddlDrop/ddlAlter/ddlReplace from .NET Query to Embedded Table