Entity Framework - Using a lookup (picklist) table with a lookup key

Posted by Dave on Stack Overflow See other posts from Stack Overflow or by Dave
Published on 2010-05-03T18:42:15Z Indexed on 2010/05/03 18:48 UTC
Read the original article Hit count: 465

Filed under:

entity

|

framework

|

sql

|

wpf

I'm working on a WPF application that is working well using the Entity Framework (3.5 SP1) for complicated table structures. The problem now is I want to get a list from the EF that includes lookups into a picklist table that has multiple picklists in it.

In SQL I would write a sub select as such:

SELECT Name, (Select typeName from PickLists where type_id = items.type_id and picklist_key=333) as Type_desc FROM Items

There are no Foreign keys for this, and the picklists table is never updated using the EF, so it is read only as far as the EF is concerned.

I'm not sure the best method to put this into the model if at all.

I'm displaying in a read-only datagrid on a dashboard.

Thanks!

© Stack Overflow or respective owner

Related posts about entity

Entity Framework + AutoMapper ( Entity to DTO and DTO to Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello. i got some problems using EF with AutoMapper. =/ for example : i got 2 related entities ( Customers and Orders ) and theyr DTO classes : class CustomerDTO { public string CustomerID {get;set;} public string CustomerName {get;set;} public IList< OrderDTO Orders {get;set;} } class… >>> More
What .Net Namespace contains Entity for use in a generic repository?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a question that I'm ashamed to ask, but I'm going to have a go at it anyway. I am creating a generic repository in asp.net mvc. I came across an example on this website which I find to be exactly what I was looking for, but there is one problem. It references an object - Entity - and I don't… >>> More
Entity Framework version 1- Brief Synopsis and Tips – Part 1

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
To Do Eager loading use Projections (for e.g. from c in context.Contacts select c, c.Addresses) or use Include Query Builder Methods (Include(“Addresses”)) If there is multi-level hierarchical Data then to eager load all the relationships use Include Query Builder methods like customers.Include("Order… >>> More
Hibernate unknown entity (not missing @Entity or import javax.persistence.Entity )

as seen on Stack Overflow - Search for 'Stack Overflow'
I've got a really simple class... import javax.persistence.Column; import javax.persistence.Entity; import javax.persistence.GeneratedValue; import javax.persistence.GenerationType; import javax.persistence.Id; import javax.persistence.Table; @Entity @Table(name = "users") public class User { … >>> More
Prevent Custom Entity being deleted from Entity Framework during Update Model Wizard

as seen on Stack Overflow - Search for 'Stack Overflow'
In Entity Framework v1 If you create a Custom Entity to map it to a Stored Procedure during FunctionImport and then Select "Update Model from Database" the Update Model Wizard removes the Custom Entity (as added Manually in the SSDL XML prior to functionImport) from the SSDL. Does anyone know if… >>> More

Related posts about framework

Baboon Framework : A revolutionary WPF framework that will save you time and effort

as seen on Code Project - Search for 'Code Project'
This is true code, what you say >>> More
Web-Application Framework - Catharsis - part VI - Framework Architecture

as seen on Code Project - Search for 'Code Project'
Catharsis web-app framework - Framework Architecture >>> More
sync Framework for Compact Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
Has anyone got sync framework to work on a mobile device as a sync mechanism in place of RDA or Merge replication? If yes, could you point me to any resources available. If one was to start a green field compact framework based application, what would one use as the sync mechanism (sync framework/RDA/Merge… >>> More
Binding not writing to datasource on .NET Compact Framework Form -- works on Full Framework

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a problem with a bound user control writing back to it's datasource on a NetCF forms application. The application is too complex to post code, so I made a toy version to show you. I create a form, usercontrol with a combobox, a class (testBind) and another class (TestLookup). I bind a property… >>> More
Unity framework - creating & disposing Entity Framework datacontexts at the appropriate time

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi there, With some kindly help from StackOverflow, I've got Unity Framework to create my chained dependencies, including an Entity Framework datacontext object: using (IUnityContainer container = new UnityContainer()) { container.RegisterType<IMeterView, Meter>(); container.RegisterType<IUnitOfWork… >>> More