Question

我有以下代码:

public class MyContext:DbContext
{
    DbSet<ABFoo> ABFoo { get; set; }
    DbSet<CDFoo> CDFoo { get; set; }
}

ABFoo and CDFoo are classes with same members. I have now and this query:

var t = context.ABFoo.Where(a => a.ID == 10);

我想让ABFoo的桌子这样改变

var t = context.ABFoo.Where(a => a.ID == 10).OnThePrefixTable("CD");

Even if query is executed on ABFoo table, i have to switch to the CDFoo table. I know i have to use ExpressionVisistors and change the "object", but do not know well what should i do! Thank you a lot!

Answer 1

您可以使用像 AutoMapper < a href=" https://github.com/AutoMapper/AutoMapper" rel = “ no follow" 这样的 lib 。 com/ AutoMapper/ AutoMapper

初始化

Mapper.CreateMap<ABFoo, CDFoo>();

以及使用

var cdFooList = Mapper.Map(context.ABFoo.SingleOrDefault(a => a.ID == 10), new CDFoo());

或返回列表

var cdFoo = Mapper.Map(context.ABFoo.Where(a => a.Id == 10).ToList(), new List<CDFoo>());

友情链接