Geek Answers Handbook

Any libraries available for executing LINQ with an Entity Attribute attribute template?

Does anyone know of any libraries that implement LINQ abstraction over the Entity Attribute Value (EAV) attribute template ? I have a large EAV database, and I'm trying to create a cleaner level of data access, and the thought of using LINQ is really attractive, so I'm looking for any code that I can use to run.

+6
linq linq-to-sql
source share
2 answers

Being involved in several LINQ providers, I can say that there are no LINQ abstractions for EAV that I know of. I think you are SOL.

I know that you said that you inherited the existing EAV database, but if you have the opportunity to use something else, perhaps this post will reject you from EAV :-)

+1
source share

With .NET 4 and dynamic objects, it is not so difficult to represent EAV as a DynamicObject, and then handle data access between the "fields" and the corresponding lines. Translating complex LINQ queries over EAV is more complicated.

However, many cases that really need EAV can often be achieved with SQL Sparse, XML data types, or NoSql document database alternatives. The difficulty of creating LINQ providers for some of these alternatives is not trivial, as can be seen from the LINQ efforts for MongoDb and RhinoDB.

0
source share

More articles:


All Articles