Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. LINQ
  4. Linq To Sql Is Faster Than Traditional Dataset Technique Or Connected Mode

Linq To Sql Is Faster Than Traditional Dataset Technique Or Connected Mode

Scheduled Pinned Locked Moved LINQ
databasequestioncsharplinq
7 Posts 5 Posters 6 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • F Offline
    F Offline
    Feras Mazen Taleb
    wrote on last edited by
    #1

    is this right ? Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

    I love Peace And Programming

    T P C R 4 Replies Last reply
    0
    • F Feras Mazen Taleb

      is this right ? Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

      I love Peace And Programming

      T Offline
      T Offline
      Tarik Guney
      wrote on last edited by
      #2

      have you googeled it ?

      I am not a perfect programmer,but i have perfect's programmers' habits.

      1 Reply Last reply
      0
      • F Feras Mazen Taleb

        is this right ? Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

        I love Peace And Programming

        P Offline
        P Offline
        Pete OHanlon
        wrote on last edited by
        #3

        Errm - this is like comparing oranges to stairs. LINQ is about integrating query features into the language so a direct comparison is tricky to say the least. Is it quicker to code? Definitely. Will it perform better than a dataset? Sometimes yes and sometimes no - it just depends on the situation. Can you link your Linq to a stored procedure? Yes.

        Deja View - the feeling that you've seen this post before.

        My blog | My articles

        F 1 Reply Last reply
        0
        • F Feras Mazen Taleb

          is this right ? Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

          I love Peace And Programming

          C Offline
          C Offline
          Colin Angus Mackay
          wrote on last edited by
          #4

          Feras Mazen Taleb wrote:

          Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

          LINQ to SQL generates a SQL string that is then compiled on the SQL Server. You can see in SQL Profiler what is actually happening.

          Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

          F 1 Reply Last reply
          0
          • P Pete OHanlon

            Errm - this is like comparing oranges to stairs. LINQ is about integrating query features into the language so a direct comparison is tricky to say the least. Is it quicker to code? Definitely. Will it perform better than a dataset? Sometimes yes and sometimes no - it just depends on the situation. Can you link your Linq to a stored procedure? Yes.

            Deja View - the feeling that you've seen this post before.

            My blog | My articles

            F Offline
            F Offline
            Feras Mazen Taleb
            wrote on last edited by
            #5

            Thanks A lot Now I'm Reading the First Book In Linq So Some Ideas need More Reading And Understanding Thanks :)

            I love Peace And Programming

            1 Reply Last reply
            0
            • C Colin Angus Mackay

              Feras Mazen Taleb wrote:

              Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

              LINQ to SQL generates a SQL string that is then compiled on the SQL Server. You can see in SQL Profiler what is actually happening.

              Upcoming FREE developer events: * Developer Day Scotland Recent blog posts: * Mixins in C#3.0 My website | Blog

              F Offline
              F Offline
              Feras Mazen Taleb
              wrote on last edited by
              #6

              Thanks Now I Can Say That there is no Diferences Between Linq to Sql And DataSet In This Part Of Idea Both Generate An Sql String Command That Have To Be Compiled On The Server Right :)

              I love Peace And Programming

              1 Reply Last reply
              0
              • F Feras Mazen Taleb

                is this right ? Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that

                I love Peace And Programming

                R Offline
                R Offline
                Roger Alsing 0
                wrote on last edited by
                #7

                >>Ofcourse We Know That Writing String Command need To Be compiled On Sql Engine But Is Linq Query Statment Need And What Is The Strory About that The true story is that if you worry about the performance on compiling sql statements on the sql server, then you are focusing and worrying about the wrong stuff.

                Blog: http://www.rogeralsing.com Projects: http://www.puzzleframework.com

                1 Reply Last reply
                0
                Reply
                • Reply as topic
                Log in to reply
                • Oldest to Newest
                • Newest to Oldest
                • Most Votes


                • Login

                • Don't have an account? Register

                • Login or register to search.
                • First post
                  Last post
                0
                • Categories
                • Recent
                • Tags
                • Popular
                • World
                • Users
                • Groups