Database-first mapping is the process of creating a set of objects and .NET classes to be used in your application from an already existing database. This approach is also known as Schema-First and Reverse Mapping. Data Access recognizes the data model, the data types and any additional information like keys and stored procedures, and then generates the object model and related C# or VB.NET code. The process is transparent and you have complete control over the created mapping by using the Create Model Wizard.
Model-First (Forward) Mapping
Model-First Mapping (also known as Forward mapping) takes your existing object model and creates an optimized database schema. In Telerik Data Access, this process is handled by the Update Database from Model wizard. It can generate your database and maintain its schema for you so that you will not have to do anything during the design phase.
Round-Trip (Mixed Mode) Mapping
The unique capability called Round-trip Mapping means you don't have to choose in advance whether to forward- or reverse-map your project. With the help of Telerik Data Access Visual Designer in Visual Studio, you employ both approaches.
Code Only Mapping (Fluent API)
If you view code as your model, preferring to write code instead of using visual assistance tools, Telerik Data Access provides Fluent Mapping API that assists you in setting-up your classes for use with Data Access. There is no need to touch a designer or work with the XML mappings.The completely automated, initial Fluent Mapping code generation is done by Data Access. The Data Access Fluent API covers 100 percent of the the functionality of the mapper, and is efficiently used by Telerik Sitefinity CMS. If required, your model can be visually adjusted in the Visual Mapping Designer.
Mapping Stored Procedures and Functions
Data Access allows you to create new or reuse existing Stored Procedures and follow the widely adopted pattern of DB logic encapsulation inside the database. Under higher security requirements, the stored procedures can be used for all insert, read, update and delete operations to inject additional checks in the database server. A Stored Procedures Editor simplifies the set-up and use of stored procedures.