Post reply

A View or Linq

  • July 4, 2012 at 8:00 am

    #260797

    Hi

    I need to display some data on a site and i am in 2 minds whether or not to use a view or a LINQ query with the web project.

    Can anyone shed any light on which is faster?

    I think there are advantages and disadvantages with maintenance for both methods. An advantage to putting it in a linq query is that the database is cluttered uneccessarily with views and procedures and functions as it is and it would be just another to add to the list.

    Thanks

  • July 4, 2012 at 8:51 am

    This was removed by the editor as SPAM

  • July 4, 2012 at 8:57 am

    #1508809

    I'm not sure i agree with your reasoning

    I can use the parameters the same in a LINQ queries as variables in my code

  • July 5, 2012 at 2:29 am

    #1508977

    erics44 (7/4/2012)

    I'm not sure i agree with your reasoning

    I can use the parameters the same in a LINQ queries as variables in my code

    Not really true. You will not benefit as much as from a stored procedure with a cached QEP.

    I don't think there's enough information to answer fully. What are you trying to achieve?

  • July 5, 2012 at 2:38 am

    #1508980

    im just trying to display a simple dataset on a web page

    couple of tables, couple of joins

    if all this is true then whats the benefit of linq?

    and wouldnt the QEP only really make a lot of difference if there were a lot of "hits" to the proc?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply