Search for existing suggestions

Table-Valued Functions

Allow table valued functions. This will enable many other scenarios such as full text search or advanced sql querying where LINQ does not support certain TSQL constructs. It can be used as a fallback or last resort whilst still allowing results to be further refined in LINQ.

TVFs are extremely powerful when used in this way with LINQ. A view or scalar function is not applicable in all scenarios as you may need to either provide a parameter or return a set of rows rather than a scalar. TVFs support these scenarios.

408 votes
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Mike Flasko shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    9 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base