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