Page tree
Skip to end of metadata
Go to start of metadata

Summary: This document provides basic information about the extension providing Entity Framework support for C#.

Extension ID


What's new?

See Entity Framework 2.0 - Release Notes for more information.


This extension provides support for Entity Framework. The calculation of Automated Function Points for your .NET analyses will be supplemented through the links between objects produced by the base .NET Analyzer and database tables, using Entity Framework CRUD operations.

In what situation should you install this extension?

If your .NET application contains Entity Framework source code and you want to view these object types and their links, then you should install this extension. More specifically the extension will identify:

  • "use" links from C# methods using Entity Framework operations to participating Database tables

Technology support

Entity Framework

Entity Framework is delivered with the .NET Framework. Therefore the following .NET frameworks are supported by this extension:



3.0 and above(tick)

Entity Framework Core

Entity Framework Core is supported when using AIP Core 8.3.x and above as Entity Framework Core is delivered with .NET Core.






Function Point, Quality and Sizing support

This extension provides the following 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
Quality and Sizing(tick)

CAST AIP compatibility

This extension is compatible with:

CAST AIP release
Supported Technology

Supported DBMS servers

This extension is compatible with the following DBMS servers:

Microsoft SQL Server


(tick)An installation of any compatible release of CAST AIP (see table above)

Download and installation instructions

Include the extension using the interface in AIP Console:

There is nothing further to do. Follow the instructions below to run a new analysis/snapshot to generate new results:

What results can you expect?

Once the analysis/snapshot generation has completed, you can view the results in the normal manner. The following links will be displayed in CAST Enlighten:

Link typeSource and destination of link Methods supported
 useInsertLinkBetween the caller .NET Class / Method objects and Database Table object
  • Add
  • AddAsync
  • AddRange
  • AddRangAsync
  • AddOrUpdate
 useDeleteLinkBetween the caller .NET Class / Method objects and Database Table object
  • Remove
  • RemoveRange
 useUpdateLinkBetween the caller .NET Class / Method objects and Database Table object
  • Update
  • UpdateRange
  • AddOrUpdate
 useSelectLinkBetween the caller .NET Class / Method objects and Database Table object
  • Find
  • FindAsync
  • First
  • FirstOrDefault
  • ToList
  • FirstOrDefaultAsync
  • ToListAsync

Code examples

Insert operation

public void AddNewContractor()        
            var contractor = ModelFakes.ContractorFake.Generate();
            var vendor = dbContext.Vendor.FirstOrDefault();
            contractor.VendorId = vendor.Id;
            Assert.AreNotEqual(0, contractor.Id);
protected override void Seed(Hth.Aepollon.Data.BackendDataAccess.AepollonContext context)      
        var listRefdefaut = context.RefDefauts.ToList();
                foreach (var refDef in listRefdefaut)
                        new MatriceDemerit { idModeOperatoire = 1, idRefDefaut = refDef.idRefDefaut, idTailleDefaut = 1,
                                             PointsDemerit = 1, PointsDemeritLineaire = 1, Tare = (decimal)0.05 },
                        new MatriceDemerit { idModeOperatoire = 1, idRefDefaut = refDef.idRefDefaut, idTailleDefaut = 2,
                                             PointsDemerit = 3, PointsDemeritLineaire = 3, Tare = (decimal)0.20 },
                        new MatriceDemerit { idModeOperatoire = 1, idRefDefaut = refDef.idRefDefaut, idTailleDefaut = 3,
                                             PointsDemerit = 5, PointsDemeritLineaire = 5, Tare = (decimal)0.50 });

Delete operation

public void RemoveEntry()        
            var rec = dbContext.Contractor.FirstOrDefault();

Update operation

public void UpdateContractorAddress()        
            var contractor = dbContext.Contractor.FirstOrDefault();
            contractor.Address = ModelFakes.ContractorFake.Generate().Address;

Select operation

public void FindEntry(int id)        
            var rec = dbContext.Vendor.Find(id);


public static void LinqToEntitiesQueries()
         using (var context = new SchoolDBEntities())
		    //Retrieve students whose name is Bill - Linq-to-Entities Query Syntax
                var students = (from s in context.Students
                                where s.StudentName == "Bill"
                                select s).ToList();
                //Retrieve students with the same name - Linq-to-Entities Method Syntax
                var studentsWithSameName = context.Students
                        .GroupBy(s => s.StudentName)
                        .Where(g => g.Count() > 1)
                        .Select(g => g.Key);

Support for EntityModelConfiguration

EntityModelConfiguration allows configuration to be performed for any entity type in a model. Support has be been provided to create links between method and table,  when table name is overridden through EntityModelConfiguration.


public DomainModel.Portaalstatus OpslaanLogin(Account account)        
            using (new LoggingMonitoredScope(LogConstants.Diagnostics))
                if (ClaimHelper.IsMeekijker())
                    return new DomainModel.Portaalstatus();
                var cacheKey = CacheSettingsHelper.CreateCacheKey(account);
                                _cacheHelper.Remove(cacheKey, CacheGroups.CacheGroupPortaalStatussen);
                DomainModel.Portaalstatus cacheItem;
                using (var dbContext = new ApfPortalenDbContext())
                    var portaalstatus =
                            p => p.AdministratieId.Equals(account.AdministratieIdentificatie) &&
		    if (portaalstatus == null)
                        portaalstatus = dbContext.Portaalstatussen.Add(new Portaalstatus());


  • Support has been provided for EntityFramework Core
  • Multiple links between caller method and database table based on CRUD operations
  • Support for Asynschronous API and batch operations
  • Positioning of bookmarks
  • Support for LINQ-to-Entities


  • SaveChanges() method of DbContext class commits the operation in the database table. Hence no useLink is created between caller method and table.
  • When the class is referenced in other code as a property, parent and child relation is created. Any CRUD operation performed on parent class is also reflected in the child class. e.g. In the below case, data is inserted in Contractor, but useInsertLink is created for both Contractor and Vendor tables, as Vendor is referenced in Contractor (foreign key).      


  • Analyzing the participating database tables is mandatory for the extension to work correctly
  • No labels