Sign in
 
HomeLibraryLearnDownloadsSupportCommunityForums
Data Developer Center > Data Platform Development Forums > ADO.NET Entity Framework and LINQ to Entities > EF and using table valued UDF with parameters

Answered EF and using table valued UDF with parameters

    •  
      Monday, September 01, 2008 2:10 PM
       
       
      Sign In to Vote
      0
      Sign In to Vote

      Hi everyone!

       

      I have a bunch of table valued UDF that takes one or more parameters, is it possible to get EF to handle them so I can get to the data? I've seen similar questions on the forum, but I havent seen an answer to how I handle TVUDFs with parameters. Is it possible, and if it is, how do I do?

       

      Hope someone can help me with this.

       

    Answers

    • Tuesday, September 02, 2008 9:51 PM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote
      You might be able to use DefiningQuery elements in your SSDL to select predefined results sets from your UDF's. You could also wrap views around them in the database and achieve the same thing, I figure. If your looking to create something like parameterized entities with EF, then I think your out of luck...such a thing isn't supported in EF v1 as far as I know, and I don't know how it could be supported (at least, not as concrete entities...perhapse a proc mapped to a function that returns entities maybe...I think that is planned for a future release of EF)