Problem with LINQ subquery "NOT IN"

.net .net-3.5 c# entity-framework linq

Question

I do not understand why this query fails.

var qTags = from tagsU in _context.ADN_ProductTagsView
where !(from o in _context.ADN_ProductTagsView
        where o.ProductID == productId
         select o.ProductTagID).Contains(tagsU.ProductTagID)
select tagsU;

Or this one:

var tagAux = from o in _context.ADN_ProductTagsView
             where o.ProductID == productId
             select o.ProductTagID;

var qTags = from tagus in _context.ADN_ProductTagsView
            where !tagAux.Contains(tagus.ProductTagID)
            select tagus ;

Both give me this error:

LINQ to Entities does not recognize the method 'Boolean Contains[Int32](System.Linq.IQueryable`1[System.Int32], Int32)' method, and this method cannot be translated into a store expression.

Can anyone help me?

1
4
5/10/2011 6:42:30 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

It seems that the implementation of the QueryProvider you're using isn't complete. I'm not familiar with the QueryProvider you're using, but maybe you can try something like this:

var qTags = from tagsU in _context.ADN_ProductTagsView
where !(from o in _context.ADN_ProductTagsView
        where o.ProductID == productId
         select o.ProductTagID).Any(tagId => tagId == tagsU.ProductTagID)
select tagsU;

Hope that helps

5
5/10/2011 5:08:36 PM

Popular Answer

Try .Any

var qTags = from tagus in _context.ADN_ProductTagsView
            where !tagAux.Any(t=> t== tagus.ProductTagID)
            select tagus ;

btw, did not run the query, so please check the syntax.

AD.Net

Related Questions

Many-to-Many Query Problems with Entity Framework - Linq To Entities

I am having problems querying many-to-many relationships in Linq To Entities. I am basically trying to replicate this query using Linq:...Select * FROM Customer LEFT JOIN CustomerInterest ON Customer.CustomerID = CustomerInterest.CustomerID LEFT JOIN Interest ON CustomerInterest.InterestID = Interest.InterestID WHERE Interest.InterestName = 'Foot...
entity-framework left-join linq-to-entities many-to-many
asked by JD.

LINQ to Entities and String have a problem. StartsWith

I'm trying to build a search page using LINQ to Entities, but the following code is giving me a runtime error about l.t.e. not recognising 'Boolean StartsWith(). The code compiles just fine. How can I work around this better than shipping the StartsWith filtering out to a stored proc?... return from dp in dents.DirectoryPersonEntrySet ...
.net entity-framework linq linq-to-entities
asked by ProfK

The method 'System' is not recognized by LINQ to Entities. Linq.IQueryable

When I try to call my repository in a Sub Select, I got this error.... IGrpTextRepository rep = new GrpTextRepository(); var query = new DetailViewModel { ViewDet = (from gh in _db.Grp select new MultiDetailViewModel { Header = gh, ...
c# entity-framework
asked by Jean-Francois

LINQ to Entities query using Sum on child object attribute has a problem.

There's an even simpler solution:...from s in services select new { s.Id, s.DateTime, Class = s.Class.Name, s.Location, s.Price, HeadCount = (int?)s.Reservations.Sum(r => r.PartySize), s.MaxSeats } ...Note the cast. This may also produce simpler SQL than @Ahmad's suggestion....Essentially, you're just helping out type i...
.net c# entity-framework linq orm
asked by Craig Stuntz

"LINQ to Entities does not support the LINQ expression node type 'Invoke'" - perplexed!

I was getting this very error and I'm using Entity Framework with ...PredicateBuilder... by Joe Albahari to build dynamic ...where... clauses. If you happen to be in the same condition, you should call the ...AsExpandable... method:...If querying with ...Entity Framework..., change the last line to this:...return objectContext.Products.AsExpandable...
asp.net c# entity-framework linq linq-to-entities
asked by Leniel Maccaferri

The ArrayIndex LINQ expression node type is not supported in LINQ to Entities.

Apparently, if you use an ...array index (aa[i])... inside an expression tree, it tries to convert that into an expression as well....Just work around it by using a separate variable:...int presId = aa[i]; Presentation press = context.Presentations.Where(m => m.PresId == presId).FirstOrDefault();
arrays c# entity-framework linq linq-to-entities
asked by Trax72

The LINQ expression node type 'Invoke' is not supported in the entity framework's LINQ to Entities.

can anyone help me out in solving my issue. I am using the code given below:...public IEnumerable<InvoiceHeader> Getdata(Expression<Func<InvoiceHeader, bool>> predicate) { return AccountsContext.InvoiceHeaders.Include("Company").Include("Currency") .Include("BusinessPartnerRoleList").Include("DocumentType") .Where(predicate); } ...
c# entity-framework expression linq predicate
asked by zaheer abbas

LINQ-To-Entity (LINQ to Entities does not support the given type member ".)

I am having difficulty understanding this problem:...Here is the T-SQL query I need to implement using LINQ to Entities...select r.ReviewID, b.BusinessID, b.Name as BusinessName ,r.Description from gb_business.Review r inner join gb_business.Business b on r.BusinessID = b.BusinessID inner join gb_listing.RegionalService rs on b.BusinessID = rs.Busi...
c# entity-framework lambda linq-to-entities
asked by itisinteresting

Subquery in Where Clause of LINQ statement

What about?...IEnumerable<postDatedCheque> _entityList = context.postDatedCheques.Where( e => context.applications.Any( x => e.appSancAdvice.application.app_id == x.app_id)); ...And if you want to use two statements, set the first as an expression function....Expression<Func<string, bool>> innerQuery = x => context.applica...
asp.net c# entity-framework linq linq-to-entities
asked by Bob Vale

LINQ to Entities does not recognize the method 'System.Linq.IQueryable`

I want to run this LINQ simple code to have record number in LINQ but result is beneath error...var model = _db2.Persons.Select( (x, index) => new { rn = index + 1, col1 = x.Id }).ToList(); ...Error:...LINQ to Entities does not recognize the method 'System.Linq.IQueryable...1[<>f__AnonymousType2...2 [System.Int3...
.net c# entity-framework linq
asked by ehsan

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow