X

Data Access Layer

DATA ACCESS LAYER

One of most important parts of the development of any data masking package is definition of a data model. When working with BizDataX Designer, it is recommended to use Microsoft¬†ADO.NET Entity Framework. Visual Studio includes comprehensive tools for working with Entity Framework. To start from existing database one can use the option “Generate data model from database”. The result is a data model representing an existing database. Details of the model are then defined visually via Entity Framework designers integrated with Visual Studio.

DataAccessLayer_1

 

DataAccessLayer_2BizDataX Design Components provide toolbar items to support common entity framework tasks. BuildEntityConnectionStringshape provides support for parameterized creation of a connection string which is needed during execution of the package.SaveDataContextChanges activity provides support for saving changes tracked by the model.

 

One could use any .Net compatible object-relational mapping tool or any other strategy to produce objects from relational data. This is because BizDataX does not make assumptions about Entity Framework usage.

In fact, BizDataX could work with any set of .Net objects. I.e. one could use LINQ To XML,custom entity objects that utilize stored procedures to manipulate data or similar. However, we recommend Entity Framework because it is an industry standard and comes with a comprehensive Visual Studio support.