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.
  • 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.

    L Offline
    L Offline
    Lost User
    wrote on last edited by
    #9

    No, and also never used it.

    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.

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #10

      No; SQL92 if I can choose, since it is rather portable.

      Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

      Sander RosselS 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.

        F Offline
        F Offline
        Forogar
        wrote on last edited by
        #11

        I took a while for me to like it but eventually I got to using it a lot and I haven't looked back.

        - I would love to change the world, but they won’t give me the source 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.

          J Offline
          J Offline
          Jorgen Andersson
          wrote on last edited by
          #12

          Only for CRUD. For heavy lifting you need to go back to proper SQL. I do use Linq2objects a lot though.

          Wrong is evil and must be defeated. - Jeff Ello

          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.

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

            Forced to use NHibernate X| But I would rather use one of these: https://www.slant.co/topics/16667/~orms-for-c[^]

            J 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.

              Mike HankeyM Offline
              Mike HankeyM Offline
              Mike Hankey
              wrote on last edited by
              #14

              Yep, it's awesome!

              They call me different but the truth is they're all the same! JaxCoder.com

              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.

                S Offline
                S Offline
                Super Lloyd
                wrote on last edited by
                #15

                Do you mean something like

                (from row in context.Person
                where row.Name.Contains("foo")
                select row).Take(10).ToList()

                Do you (erroneously) "oppose it" to something like

                context.Person.Where(x => x..Name.Contains("foo")).Take(10).ToList()

                I guess I do then... but I usually use both syntax. Sometimes in the same query.

                A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!

                1 Reply Last reply
                0
                • R RickZeeland

                  Forced to use NHibernate X| But I would rather use one of these: https://www.slant.co/topics/16667/~orms-for-c[^]

                  J Offline
                  J Offline
                  Jorgen Andersson
                  wrote on last edited by
                  #16

                  Or you can roll your own.

                  Wrong is evil and must be defeated. - Jeff Ello

                  R 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
                    MadMyche
                    wrote on last edited by
                    #17

                    I use it almost weekly; as an example of what not to do

                    Director of Transmogrification Services Shinobi of Query Language Master of Yoda Conditional

                    1 Reply Last reply
                    0
                    • J Jorgen Andersson

                      Or you can roll your own.

                      Wrong is evil and must be defeated. - Jeff Ello

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

                      Too busy with community engineering on CodeProject nowadays :-\

                      J 1 Reply Last reply
                      0
                      • L Lost User

                        No; SQL92 if I can choose, since it is rather portable.

                        Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

                        Sander RosselS Offline
                        Sander RosselS Offline
                        Sander Rossel
                        wrote on last edited by
                        #19

                        How often have you ported it?

                        Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                        L 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.

                          P Offline
                          P Offline
                          PIEBALDconsult
                          wrote on last edited by
                          #20

                          Frack, no.

                          1 Reply Last reply
                          0
                          • Sander RosselS Sander Rossel

                            How often have you ported it?

                            Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

                            L Offline
                            L Offline
                            Lost User
                            wrote on last edited by
                            #21

                            I've got both Windows and Kubuntu running here; not using the database-servers dailect of SQL makes it easy to switch databases.

                            Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

                            1 Reply Last reply
                            0
                            • R RickZeeland

                              Too busy with community engineering on CodeProject nowadays :-\

                              J Offline
                              J Offline
                              Jorgen Andersson
                              wrote on last edited by
                              #22

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

                              Wrong is evil and must be defeated. - Jeff Ello

                              R 1 Reply Last reply
                              0
                              • 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
                                          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