title: Stored procedure search using entity framework
body: <p>I want to implement a search logic that I have seen and use. It works like this: </p>
  
  <p>There is stored procedure that is loaded in entity framework and it is used as a method in C#,  it takes parameters in order to perform search. That method is returning list of views (DB View). The views in list have just some of the properties that are needed to be shown in the gird. For example I am searching for users by some parameters and result is list of users. Instead of returning list of User object I am using a vUser view that contains only properties that will be listed on gird. For example ID, Name, and Surname. But still data is correct because stored procedure search is done against table Users in database. </p>
  
  <p>View is also loaded as C# object in entity framework. 
  I am using SQL Server 2005.</p>
  
  <p>How I can implement this? </p>
  
  <p>thank you very much.</p>