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

Dapper

Scheduled Pinned Locked Moved The Lounge
question
47 Posts 22 Posters 1 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.
  • realJSOPR realJSOP

    Besides all of the above, I didn't ask if anyone had used EF.

    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
    -----
    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
    -----
    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

    S Offline
    S Offline
    Slacker007
    wrote on last edited by
    #20

    Fair enough, John.

    N 1 Reply Last reply
    0
    • Richard DeemingR Richard Deeming

      Very good. It's not trying to do everything, like EF or NHibernate; it just makes certain tasks with raw ADO.NET a lot easier.


      "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

      realJSOPR Offline
      realJSOPR Offline
      realJSOP
      wrote on last edited by
      #21

      I looked in NuGet, and there's a crapload of dapper-related stuff in there. What's worth getting?

      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
      -----
      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
      -----
      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

      Richard DeemingR 1 Reply Last reply
      0
      • realJSOPR realJSOP

        C# is simply a copy of java, but without the cross-platform capabilities.

        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
        -----
        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
        -----
        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

        S Offline
        S Offline
        Sascha Lefevre
        wrote on last edited by
        #22

        I'm no Java guy but observing the news Kent posts about Java language development it looks like the table has turned and Java becomes a copy of C# ;P More on topic: If you're looking for a non-Microsoft "heavy" ORM then I would suggest to take a look at VITA[^]. I haven't used it myself yet but it sounds really good.

        If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

        1 Reply Last reply
        0
        • realJSOPR realJSOP

          I looked in NuGet, and there's a crapload of dapper-related stuff in there. What's worth getting?

          ".45 ACP - because shooting twice is just silly" - JSOP, 2010
          -----
          You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
          -----
          When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

          Richard DeemingR Offline
          Richard DeemingR Offline
          Richard Deeming
          wrote on last edited by
          #23

          I've only used the core package[^] so far. Dapper.Contrib[^] looks interesting, and is maintained by the same team: Dapper.Contrib - more extensions for dapper[^]


          "These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer

          "These people looked deep within my soul and assigned me a number based on the order in which I joined" - Homer

          1 Reply Last reply
          0
          • S Slacker007

            Fair enough, John.

            N Offline
            N Offline
            Nish Nishant
            wrote on last edited by
            #24

            BTW, a few folks claim that Dapper's faster than EF6 - so I guess there's that.

            Regards, Nish


            Website: www.voidnish.com Blog: voidnish.wordpress.com

            S S J 3 Replies Last reply
            0
            • N Nish Nishant

              BTW, a few folks claim that Dapper's faster than EF6 - so I guess there's that.

              Regards, Nish


              Website: www.voidnish.com Blog: voidnish.wordpress.com

              S Offline
              S Offline
              Sascha Lefevre
              wrote on last edited by
              #25

              It most certainly is - but that's apples and oranges.

              If the brain were so simple we could understand it, we would be so simple we couldn't. — Lyall Watson

              1 Reply Last reply
              0
              • N Nish Nishant

                BTW, a few folks claim that Dapper's faster than EF6 - so I guess there's that.

                Regards, Nish


                Website: www.voidnish.com Blog: voidnish.wordpress.com

                S Offline
                S Offline
                Slacker007
                wrote on last edited by
                #26

                I have heard of Dapper, and that is about all. I have the most experience with EF but I am not going on the record to say that it is the best. I'm sure there are applications best suited for Dapper. I found this to be interesting. The conclusion at the end is the most important. Dapper looks to be faster in a lot of respects. Interesting. Don't Panic Labs – Speed Comparison: Dapper vs Entity Framework[^] Looks like Stackoverflow uses Dapper.

                A 1 Reply Last reply
                0
                • N Nish Nishant

                  BTW, a few folks claim that Dapper's faster than EF6 - so I guess there's that.

                  Regards, Nish


                  Website: www.voidnish.com Blog: voidnish.wordpress.com

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

                  The difference is big! If you want faster you have to run your own, like I did.

                  Wrong is evil and must be defeated. - Jeff Ello

                  1 Reply Last reply
                  0
                  • realJSOPR realJSOP

                    Slacker007 wrote:

                    EF 6 has ... Any reason why you can't use that?

                    It's from Microsoft.

                    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                    -----
                    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                    -----
                    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                    D Offline
                    D Offline
                    David Crow
                    wrote on last edited by
                    #28

                    Aren't .NET and Mono both from Microsoft, or are you targeting some other platform?

                    "One man's wage rise is another man's price increase." - Harold Wilson

                    "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

                    "You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

                    realJSOPR 1 Reply Last reply
                    0
                    • realJSOPR realJSOP

                      Does anyone here use the Dapper ORM?

                      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                      -----
                      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                      -----
                      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                      S Offline
                      S Offline
                      stoneyowl2
                      wrote on last edited by
                      #29

                      Not that one, but I have used something called 'PetaPoco', which is kinda based on Dapper. The nice thing, to me, is it is a single .cs file that can be included right in you solution. He also has a later version that is a normal assembly. You will probably need to google 'PetaPoco' to find it.

                      C 1 Reply Last reply
                      0
                      • K Kent Sharkey

                        I haven't used it, but I understand that there is an article in next month's MSDN Magazine about it (should be on the site on Monday). Julie Lerman (she of much EF writing) liked it.

                        TTFN - Kent

                        N Offline
                        N Offline
                        Nagy Vilmos
                        wrote on last edited by
                        #30

                        If Julie is s fan then that is a pretty big endorsement.

                        veni bibi saltavi

                        1 Reply Last reply
                        0
                        • realJSOPR realJSOP

                          Does anyone here use the Dapper ORM?

                          ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                          -----
                          You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                          -----
                          When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                          P Offline
                          P Offline
                          pt1401
                          wrote on last edited by
                          #31

                          I've used it a lot. It's excellent, but in large projects its best used with some form of POCO-generator such as Codesmith to auto-generate your DAL classes on your build server. Dapper is very fast and, even more importantly IMO, it doesn't get in your way.

                          1 Reply Last reply
                          0
                          • realJSOPR realJSOP

                            Does anyone here use the Dapper ORM?

                            ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                            -----
                            You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                            -----
                            When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                            S Offline
                            S Offline
                            Ste S
                            wrote on last edited by
                            #32

                            I've used Dapper a few times. I really like it and as others have said it generally gets out of the way and works well at mapping your sql to an object or collection of objects. I use it with Dapper extensions which makes simple selecting/updating etc pretty simple. I invested a lot of time in learning EF and it was hard to make the move but honestly I've never found a need to go back to using EF. EF seems overly complex, at least for my needs and I fail to see a good reason for using EF over a micro orm like Dapper or PetaPoco (which i also like).

                            1 Reply Last reply
                            0
                            • realJSOPR realJSOP

                              C# is simply a copy of java, but without the cross-platform capabilities.

                              ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                              -----
                              You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                              -----
                              When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

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

                              I just finished a small project running ASP.NET 5 on a Docker container running Ubunutu hosted in Azure :rose: Exciting times ahead I think :)

                              The whole thing's rigged to blow, touch those tanks and "boooom"!

                              1 Reply Last reply
                              0
                              • realJSOPR realJSOP

                                Slacker007 wrote:

                                Well, that is not really a good reason.

                                It's always been a good reason in the past. And I like living in the past.

                                ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                -----
                                You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                -----
                                When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

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

                                What do you use instead of Visual Studio?

                                The whole thing's rigged to blow, touch those tanks and "boooom"!

                                realJSOPR 1 Reply Last reply
                                0
                                • L Lost User

                                  What do you use instead of Visual Studio?

                                  The whole thing's rigged to blow, touch those tanks and "boooom"!

                                  realJSOPR Offline
                                  realJSOPR Offline
                                  realJSOP
                                  wrote on last edited by
                                  #35

                                  I use edlin to edit my code, and manually compile everything (yeah it takes a lot longer, but it's hella efficient code).

                                  ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                  -----
                                  You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                  -----
                                  When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                                  L 1 Reply Last reply
                                  0
                                  • realJSOPR realJSOP

                                    I use edlin to edit my code, and manually compile everything (yeah it takes a lot longer, but it's hella efficient code).

                                    ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                    -----
                                    You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                    -----
                                    When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

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

                                    Wow, that looks like the hard way of doing things[^] :laugh: I guess you're paid by the hour? :laugh:

                                    The whole thing's rigged to blow, touch those tanks and "boooom"!

                                    realJSOPR 1 Reply Last reply
                                    0
                                    • L Lost User

                                      Wow, that looks like the hard way of doing things[^] :laugh: I guess you're paid by the hour? :laugh:

                                      The whole thing's rigged to blow, touch those tanks and "boooom"!

                                      realJSOPR Offline
                                      realJSOPR Offline
                                      realJSOP
                                      wrote on last edited by
                                      #37

                                      Most things that are worth doing start out hard. And that's true for so many things in life. :)

                                      ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                      -----
                                      You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                      -----
                                      When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                                      1 Reply Last reply
                                      0
                                      • D David Crow

                                        Aren't .NET and Mono both from Microsoft, or are you targeting some other platform?

                                        "One man's wage rise is another man's price increase." - Harold Wilson

                                        "Fireproof doesn't mean the fire will never come. It means when the fire comes that you will be able to withstand it." - Michael Simmons

                                        "You can easily judge the character of a man by how he treats those who can do nothing for him." - James D. Miles

                                        realJSOPR Offline
                                        realJSOPR Offline
                                        realJSOP
                                        wrote on last edited by
                                        #38

                                        I was just making a comment. I'm not targeting anything.

                                        ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                        -----
                                        You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                        -----
                                        When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                                        1 Reply Last reply
                                        0
                                        • realJSOPR realJSOP

                                          Does anyone here use the Dapper ORM?

                                          ".45 ACP - because shooting twice is just silly" - JSOP, 2010
                                          -----
                                          You can never have too much ammo - unless you're swimming, or on fire. - JSOP, 2010
                                          -----
                                          When you pry the gun from my cold dead hands, be careful - the barrel will be very hot. - JSOP, 2013

                                          M Offline
                                          M Offline
                                          Mark Jerzykowski
                                          wrote on last edited by
                                          #39

                                          I use it. We wrote a slightly bigger ORM thing to go on top of it: Dashing[^] And yes, much time was spent on the name.

                                          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