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.

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