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. The Lounge
  3. Just Curious

Just Curious

Scheduled Pinned Locked Moved The Lounge
csharpdatabaselinqhelpquestion
32 Posts 23 Posters 0 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.
  • J Jorgen Andersson

    You mean rolling your own and posting an article about it? :)

    Wrong is evil and must be defeated. - Jeff Ello

    R Offline
    R Offline
    RickZeeland
    wrote on last edited by
    #23

    Quote:

    A nod's as good as a wink to a blind bat.

    :-\

    1 Reply Last reply
    0
    • K Kevin Marois

      How many of you are using Linq-To-SQL? Just a quick poll

      If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

      J Offline
      J Offline
      Jacquers
      wrote on last edited by
      #24

      I used to... but not anymore.

      1 Reply Last reply
      0
      • K Kevin Marois

        How many of you are using Linq-To-SQL? Just a quick poll

        If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

        D Offline
        D Offline
        DJ van Wyk
        wrote on last edited by
        #25

        Daily, yes. You just have to be very careful with how you write the queries and constantly inspect what Linq-to-SQL projects into actual SQL. Sometimes Linq is so clever that it project terrible and slow queries but in most cases you can fix it by "rewording" your Linq queries. I believe Entity Framework has the same projection problem.

        My plan is to live forever ... so far so good

        1 Reply Last reply
        0
        • K Kevin Marois

          How many of you are using Linq-To-SQL? Just a quick poll

          If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

          D Offline
          D Offline
          decaffeinatedMonkey
          wrote on last edited by
          #26

          Entity Framework Core for me. I like how it does migrations, and if done right, it can be portable across multiple database engines.

          1 Reply Last reply
          0
          • K Kevin Marois

            How many of you are using Linq-To-SQL? Just a quick poll

            If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

            D Offline
            D Offline
            darktrick544
            wrote on last edited by
            #27

            Never have, I dont mind writing proper code

            1 Reply Last reply
            0
            • K Kevin Marois

              How many of you are using Linq-To-SQL? Just a quick poll

              If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

              M Offline
              M Offline
              Mario Luis
              wrote on last edited by
              #28

              Nope. MS did suggest a while ago that it should not be used production wise, rather use EF or some such.

              1 Reply Last reply
              0
              • K Kevin Marois

                How many of you are using Linq-To-SQL? Just a quick poll

                If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

                O Offline
                O Offline
                obermd
                wrote on last edited by
                #29

                Nope. Since I write mainly in VB I find the Linq syntax to be very cumbersome and hard to use. When I write in C# I'm far more likely to use Linq simply because the lambda syntax is far easier to read and use. In neither case do I use Linq -> SQL

                1 Reply Last reply
                0
                • M Marc Clifton

                  Me. Love it.

                  Latest Articles:
                  16 Days: A TypeScript application from concept to implementation

                  A Offline
                  A Offline
                  agolddog
                  wrote on last edited by
                  #30

                  Me too.

                  1 Reply Last reply
                  0
                  • K Kevin Marois

                    How many of you are using Linq-To-SQL? Just a quick poll

                    If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

                    V Offline
                    V Offline
                    ventureaaron
                    wrote on last edited by
                    #31

                    It is the recommended way for SharePoint 2010 CRUD according to "SharePoint 2010 Dev with VS2010" by E. Carter et al. I use it and love having some of that back end taken care of (and i've really grown to like Linq). but as someone else said i use straight up SQL when the going gets tough.

                    1 Reply Last reply
                    0
                    • K Kevin Marois

                      How many of you are using Linq-To-SQL? Just a quick poll

                      If it's not broken, fix it until it is. Everything makes sense in someone's mind. Ya can't fix stupid.

                      B Offline
                      B Offline
                      BrentHolmstrom
                      wrote on last edited by
                      #32

                      Tried it for a project but quickly had to abandon it. Found it too rigid. If you try using against a many databases. When one database adds a field, it completely breaks querying the table. Though I enjoyed learning about CROSS APPLY from examining it but discovered that it hits a cap where it performs better than anything else in a limited use environment, but once you pass a threshold it takes down systems.

                      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