How to select with Linq to Entity from one table with two different variables?

Posted by George on Stack Overflow See other posts from Stack Overflow or by George
Published on 2010-05-01T18:04:38Z Indexed on 2010/05/01 18:07 UTC
Read the original article Hit count: 140

Filed under:

linq-to-entities

I have a table where I have items under two different types as you can see below: How can I select from this table with Linq to Entity to get the result with two variables?

where ItemType = Type1 and ItemType == Type2
.... select new {typeOne == "", typeTwo == ""};

ID ItemName     ItemType

1 ItemOne       Type1
2 ItemTwo       Type1
3 ItemThree     Type1
4 ItemFour      Type1
5 ItemTFive     Type2
6 ItemSix       Type2
7 ItemSeven     Type2
8 ItemEight     Type2

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
Linq to Entities : using ToLower() on NText fields

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using SQL Server 2005, with a case sensitive database.. In a search function, I need to create a Linq To Entities (L2E) query with a "where" clause that compare several strings with the data in the database with these rules : The comparison is a "Contains" mode, not strict compare : easy as… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
deploying applications that use LINQ to Entities.

as seen on Stack Overflow - Search for 'Stack Overflow'
HI COMUNITY!!!! I want to use L2E since it s very convenient to my company's apps, I created a demo project, the demo does run on every machine but when I, lets say, press a button that has some code that uses the entity I get this error: specified store provider cannot be found in the configuration… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Developer IT

How to select with Linq to Entity from one table with two different variables? - Developer IT

How to select with Linq to Entity from one table with two different variables?

linq-to-entities

Related posts about linq-to-entities

HELP: deploying applications that use LINQ to Entities.

Linq to Entities : using ToLower() on NText fields

LiNQ to Entities, Include less

deploying applications that use LINQ to Entities.

LINQ To Entities - Items, ItemCategories & Tags

Categories cloud