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.

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