Missing tables and procedures for .NET - 1.0
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 |
✅ |
Function Point, Quality and Sizing support
- Function Points (transactions): a green tick indicates that OMG Function Point counting and Transaction Risk Index are supported
- Quality and Sizing: a green tick indicates that CAST can measure size and that a minimum set of Quality Rules exist
| Function Points (transactions) |
Quality and Sizing |
| ✅ |
❌ |
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) |
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 |
Links
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 Missing Table/SQL Missing Table
- call from .NET Query to Missing Procedure/SQL Missing
Procedure