反正有没有在linq实体查询中生成自定义sql？-Isthereanywaytogeneratecustomsqlinalinqtoentitiesquery?

I have a database where I have a table that will have columns added/removed by the customer (We can't change this behavior, it's legacy).

我有一个数据库,我有一个表,将有客户添加/删除列(我们不能改变这种行为,它的遗产)。

This table has a foreign key to a table that I've mapped through EF. I'm trying to figure out a way to sort/filter the parent table by one of the dynamic columns using EF.

此表具有我通过EF映射的表的外键。我试图找出一种使用EF对其中一个动态列排序/过滤父表的方法。

Is there anyway to add to the query for a column that doesn't exist until runtime?

无论如何要添加到查询中直到运行时才存在的列?

My current solution is to get all the records, then get the corresponding records in the other (dynamic)table as a dataset, and combine the two in a new class, and sort a list of those objects.

我目前的解决方案是获取所有记录,然后将另一个(动态)表中的相应记录作为数据集,并将两者合并到一个新类中,并对这些对象的列表进行排序。

Unfortunately, I have no code to show for this as my already working solution isn't what I want, but I have no idea where to start with a better, optimal solution.

不幸的是,我没有代码可以显示,因为我已经在工作的解决方案不是我想要的,但我不知道从哪里开始更好,最优的解决方案。

1 个解决方案