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

    John Simmons / outlaw programmer wrote:

    It's from Microsoft.

    Well, that is not really a good reason. You have to have a better reason for that, I would think. Our shop/company has been using EF 5 and 6 with great results. We recently went to Code First, and I like that too, despite my initial hesitation...to change.

    R Offline
    R Offline
    realJSOP
    wrote on last edited by
    #19

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

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

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

                                  R 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"!

                                    R Offline
                                    R 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
                                    • R 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"!

                                      R 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"!

                                        R Offline
                                        R 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

                                          R Offline
                                          R 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
                                          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