Entity Framework 6 - Knowledge Base (KB)

AutoMapper + Entity Framework ( Entity to DTO and DTO to Entity )

I've got some problems using EF with AutoMapper. =/...for example :...I've got 2 related entities ( Customers and Orders ) and they're DTO classes : ... class CustomerDTO { public string CustomerID {get;set;} public string CustomerName {get;set;} ...

DTO Pattern + Lazy Loading + Entity Framework + ASP.Net MVC + Auto Mapper

Firstly, Sorry For lengthy question but I have to give some underlying information....We are creating an Application which uses ASP.net MVC, JQuery Templates, Entity Framework, WCF and we used POCO as our domain layer. In our application, there is a WCF ...

Domain vs DTO vs ViewModel - How and When to use them?

In a Multi-layer project with Domain layer (DL)/Business (Service) Layer (BL)/Presentation Layer (PL), what is the best approach to deliver Entities to the Presentation Layer?...DO => Domain Object; DTO = Domain Transfer Object; VM => View Model; V => Vie...

Mapping entities to DTOs without duplicated code

I'm trying to get my head around this issue where I am using the Entity Framework (6) in an N-tier application. Since data from the repository (which contains all communication with the database) should be used in a higher tier (the UI, services etc), I n...

Can Automapper use an entity's navigation properties to pull values from related entities

Is Automapper able to drill down into an entityy navigation properties to map to a DTO class? Below is what I am doing to map results from an Entity Framework query to a DTO:... public List<ProductRequestDetailDto> GetProductRequestExtendedDetai...

How to work with DTOs in Controller of WebAPI?

I'm a bit confused how to use DTOs in my WebAPI controllers. I'm using the Database first concept of Entity Framework. The following Entity Data Model was generated:...//Generated class by EDM: public partial class Address { [System.Diagnostic...

How mapping many to many with automapper

I have many to many relation for tables functions and roles and I have association table RolesFunctions. In the RolesFunctions I have row id ( IdFunctions and IdRoles Both its a prime key). ...the problem... is when I map function with functionDTO and rol...

Changing the output DTO (return value) of the GetAll method in an AsyncCrudAppService

I'm using ABP's ...AsyncCrudAppService... in my AppServices. Here's my interface:...public interface IAssetRequisitionAppService : IAsyncCrudAppService <AssetRequisitionDto, Guid, GetAllInput, AssetRequisitionDto, AssetRequisitionDto, AssetRequisition...

How do I restrict the number of columns used in an INSERT when using EntityFramework?

Let's say you have an Entity with 26 columns. It matches the corresponding table which also has 26 columns....From time to time I would like to be able to send fewer columns in an INSERT (Add) operation than are specified in the entity because of certain...

Disable deletion for records with dependencies

I want to delete records from my database only which don't have any dependencies. ...eg...:- ...Company... Table has ...Company Pk... primary key and it is the foreign key for ...department... table and ...location... table. So the system should not allow...