Problem with LINQ subquery "NOT IN"

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

Question

I'm not sure why this query is unsuccessful.

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 maybe this:

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 ;

I get this problem from both:

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 somebody assist 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 QueryProvider you're using doesn't have a full implementation. Though I don't know much about the QueryProvider you're using, maybe you could try something similar:

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's helpful.

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

Popular Answer

Any try

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

By the way, the query was not performed, so double-check the syntax.

AD.Net

Related Questions

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

I am having trouble using Linq To Entities to query many-to-many relationships. I'm essentially attempting to use Linq to execute this query:...Select * FROM Customer LEFT JOIN CustomerInterest ON Customer.CustomerID = CustomerInterest.CustomerID LEFT JOIN Interest ON CustomerInterest.InterestID = Interest.InterestID WHERE Interest.InterestName =...
entity-framework left-join linq-to-entities many-to-many
asked by JD.

LINQ to Entities and String have a problem. StartsWith

I'm attempting to use LINQ to Entities to create a search page, however the following code is throwing a runtime error about l.t.e. not understanding "Boolean StartsWith" (). The code successfully builds. What alternative to transporting the StartsWith filtering out to a stored proc can I use to get around this?... return from dp in dents.Direct...
.net entity-framework linq linq-to-entities
asked by ProfK

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

I received this problem while attempting to use my repository in a Sub Select.... 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 is an even easier remedy:...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 } ...Observe the cast. In comparison to @Ahmad's idea, this could also result in easier SQL....In essence, all you're doing is ...
.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 seeing this problem when building a dynamic database using Entity Framework by Joe Albahari....where... clauses. If you find yourself in a similar situation, you should contact the...AsExpandable... method:...If using the ...Enterprise Framework... query, alter the last line to read as follows:...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.

Evidently, if you use an...array index (aa[i])... It attempts to make it into an expression inside of an expression tree....Just use a different variable as a workaround:...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 somebody assist me in resolving my problem? I'm use the code 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'm having trouble comprehending this issue:...Here is the T-SQL query I must use LINQ to Entities to implement....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.BusinessID ...
c# entity-framework lambda linq-to-entities
asked by itisinteresting

Subquery in Where Clause of LINQ statement

Then what?...IEnumerable<postDatedCheque> _entityList = context.postDatedCheques.Where( e => context.applications.Any( x => e.appSancAdvice.application.app_id == x.app_id)); ...Additionally, make the first statement an expression function if you wish to use two statements....Expression<Func<string, bool>> innerQuery = x =>...
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 execute this basic LINQ code to create a record number in LINQ, however the outcome is below 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 ...
.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