DevForce Community Forum : Selecting different views using the Entity Framework http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Selecting different views using the Entity Framework Mon, 13 Apr 2026 08:08:30 -700 Mon, 10 Jan 2011 16:47:13 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2429 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Selecting different views using the Entity Framework : Hi Stephane;This question is outside... http://www.ideablade.com/forum/forum_posts.asp?TID=2429&PID=9615#9615 Author: DenisK
Subject: 2429
Posted: 10-Jan-2011 at 4:47pm

Hi Stephane;

This question is outside of DevForce support scope. Someone from the Professional Services will be in touch with you soon.
]]> Mon, 10 Jan 2011 16:47:13 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2429&PID=9615#9615 Selecting different views using the Entity Framework : Hi Guys, I hope this is the... http://www.ideablade.com/forum/forum_posts.asp?TID=2429&PID=9599#9599 Author: MrTouya
Subject: 2429
Posted: 09-Jan-2011 at 7:03am

Hi Guys,

I hope this is the right place for this question. I have an application that I am trying to convert from using a straight ADO.NET to sql server connection and I want to use the Entity Framework. In my app the when the user logs on they are presented with a drop down box of views that are associated with the user's ID number. For example, let's say the following views exists:

  • 3050_CUSTOMER_VIEW
  • 3050_ORDERS_VIEW
  • 3051_CUSTOMER_VIEW
  • 3051_ORDERS_VIEW

 Once the user selects logs on, they only see the customer view that they are allowed to see. A user with ID number 3050 will only be able to see the 3050 views and a user with the ID 3051 will only be able to see the 3051 views. The underlying views have complex aggregates that are different for each user.

How can I create an Entity Model that can support something like this? I was thinking of using a stored procedure mapped to an entity, but I am not sure how to acheive this.

In my C# app I want to present a drop down box with views that are associcated with a users's ID and the user will be able to build queries that execute against the selected view.

Can someone point me in the right direction?

Thanks,

Stephane

]]> Sun, 09 Jan 2011 07:03:41 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2429&PID=9599#9599