Sql server procedure convert to Entity Function RRS feed

  • Question

  • case 1:

    when I create a procedure with two temporary table joining in sql server and generated Entity in Entityframework

    It produce a function with return type int . As the result I can not access the query values in linq.

    Case 2:

    But when I create the same procedure by joining two query without taking any temporary tabel

    It produce the the function with object returning.As the result I can access the query values in linq.

    But Temporary table joining gives better perfermance rather than query joining

    Friday, November 10, 2017 12:45 PM