Table-values function support

10 posts, 0 answers
  1. Michel Corbin
    Michel Corbin avatar
    20 posts
    Member since:
    Apr 2010

    Posted 05 May 2010 Link to this post

    Hi,

    In many of my projects, I have a lot of queries that use table-values function and I want to know if OpenAccess have support with linq.

    Thank you
  2. TSE
    TSE avatar
    381 posts
    Member since:
    Sep 2008

    Posted 06 May 2010 Link to this post

    Hi Samuel,

    I don't know with LINQ, but we use CLR-UDF in a minimal set of our queries. We still query through the scope and get persistent instances back, but the query is written in SQL. This ensures that the full query is psuhed directly to the server.
    I don't think you can you can mix the query languages or do this in LINQ alone, unless OA detects a CLR-UDF as being such a thing and pushes it to the server.

    Anyone from Telerik to elaborate on this one?

    Regards

    Henrik
  3. DevCraft banner
  4. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 06 May 2010 Link to this post

    Hi Samuel Tremblay,

    Unfortunately currently table valued functions are not something that is supported by our LINQ implementation. The good news are that we are heavily investing time in our LINQ implementation and lots of missing functionality will be introduced with our next releases.

    Kind regards,
    Petar
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  5. Michel Corbin
    Michel Corbin avatar
    20 posts
    Member since:
    Apr 2010

    Posted 06 May 2010 Link to this post

    Finally, I will use functions (in c#) that returns IQueryable result. This function will have the parameters equivalent of my table-valued-function. Finally, I can create a linq query that use the result of the IQueryable function instead of the result of a table. With this, I have exactly the same result as table-valued-function except things like performance, security, etc... but in my view, this will satisfy my needs.

    Thank you all.
  6. TSE
    TSE avatar
    381 posts
    Member since:
    Sep 2008

    Posted 07 May 2010 Link to this post

    Hi Samuel,

    Great solution to expose the TVF as an IQueryable.


  7. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 12 May 2010 Link to this post

    Hello Samuel Tremblay,

    Indeed that is a nice solution. We are happy that you have found your way around. Should you face any further difficulties please do not hesitate to contact us.

    All the best,
    Petar
    the Telerik team

    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
  8. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 23 Nov 2010 Link to this post

    Hey There,
      Any update on the Linq Table Function support?

    A project using these just hit me again

    Steve
  9. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 26 Nov 2010 Link to this post

    Hi Steve,

     We do not provide a direct support for table valued functions and Linq. Does the solution that Samuel provided does not work for you?

    Greetings,
    Petar
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
  10. Steve
    Steve avatar
    1851 posts
    Member since:
    Dec 2008

    Posted 26 Nov 2010 Link to this post

    Right I know you DON'T....but CAN you :)

    That and SP mapping to objects types?
  11. PetarP
    Admin
    PetarP avatar
    754 posts

    Posted 01 Dec 2010 Link to this post

    Hello Steve,

     We don't have plans for that functionality just yet. We do plan to provide stored procedures that are mappable to specific types (even projections) but that is something that will be available around Q1 2011.

    Sincerely yours,
    Petar
    the Telerik team
    Accelerate your learning with industry's first Telerik OpenAccess ORM SDK. Download today.
Back to Top
DevCraft banner