[.NET Core version] : Translates computed properties in LINQ queries into their implementation (based on Microsoft.Linq.Translations).
$ dotnet add package Linq.PropertyTranslator.CoreThis is a .NET Core / .NET Standard port of the PropertyTranslator (https://github.com/peschuster/PropertyTranslator).
The following frameworks are supported:
Translates computed properties in LINQ queries into their implementation (based on Microsoft.Linq.Translations).
PropertyTranslator exchanges properties in linq queries before execution. This is especially useful if the underlying LINQ provider does not support some kind of operation or you want to add client-side calculations in your business logic to e.g. an EntityFramework model.
For a general introduction into the topic, have a look at this blog post. PropertyTranslator actually is a enhancement of the presented solution in the post.
For an introduction specifically to PropertyTranslator have a look at these two blog posts: LINQ: How to dynamically map properties and PropertyTranslator and Interfaces
PropertyTranslator plays well together with QueryInterceptor.Core and thus can be added to every query in some kind of "data context" or general table / ObjectSet provider.
Furthermore it internally adds one more layer of abstraction to allow property translation depending on the ui culture of the current thread.
A POCO entity class from EntityFramework. Although in the database only a FirstName and a LastName field exists, the property can be used in queries, because right before execution of the query it is translated to .
NameFirstName + ' ' + LastNamepublic class Person
{
private static readonly CompiledExpressionMap<Person, string> fullNameExpression =
DefaultTranslationOf<Person>.Property(p => p.FullName).Is(p => p.FirstName + " " + p.LastName);
public string FullName
{
get { return fullNameExpression.Evaluate(this); }
}
public string FirstName { get; set; }
public string LastName { get; set; }
}The context: a database table, mapped with entity framework to POCO entity classes with two fields: EnglishName and GermanName. With the following snippet, you can use the Name property in linq queries which resolves to the name (either EnglishName or GermanName) depending on the current ui culture.
public class Country
{
private static readonly CompiledExpressionMap<Country, string> nameExpression =
DefaultTranslationOf<Country>.Property(c => c.Name).Is(c => c.EnglishName);
static Country()
{
DefaultTranslationOf<Country>.Property(c => c.Name).Is(c => c.EnglishName, 'en');
DefaultTranslationOf<Country>.Property(c => c.Name).Is(c => c.GermanName, 'de');
}
public string Name
{
get { return nameExpression.Evaluate(this); }
}
public string EnglishName { get; set; }
public string GermanName { get; set; }
}You can enable PropertyTranslator by adding the PropertyVisitor to your EntityFramework ObjectSets (of course it works not only with EntityFramework but with any LINQ provider):
using QueryInterceptor;
using PropertyTranslator;
public class MyDataContext
{
ObjectContext context = new MyEfContext();
public IQueryable<Person> PersonTable
{
get
{
var objectSet = context.CreateObjectSet<Person>("Persons");
return objectSet.InterceptWith(new PropertyVisitor());
}
}
}Entity Framework Extensions and Dapper Plus are major sponsors and proud to contribute to the development of Linq.PropertyTranslator.Core.
