C# Dapper Repository

New Direction

I had created a framework for a new Microsoft C# MVC web application at work using XML Serialization for the database to POCO conversion and straight ADO for data transmission. We had an architecture review and were asked to try Dapper instead. The word was that other units were using it.

 We looked around but didn't find anyone using Dapper Micro ORM with a repository pattern, especially for hierarchical data, so last weekend I set out to create one that I'm sharing on my Dropbox:

 https://www.dropbox.com/s/n5v1o2zdyhyvjyf/DapperDemo.zip?dl=0 

 This link is to a .zip file. Hopefully have all the goodies you need to view the code and run it. 

The Zip Folder Contents


 In the “Database” folder I have a document with some description about the solution. I also have 2 scripts to create and populate a simple database with 3 tables. 

 There is a Main table, a Child table with a many to one relationship to the Main table, and an Auxiliary table with a many to one relationship to the Child table. That’s 3 levels of hierarchy!

 In the Visual Studio solution, the functionality is exercised through a test project; there is no actual interface.

I’ve tried out the Dropbox solution on 3 PCs and it works but there can be some fiddling getting the database installed but I’m sure everyone here can figure it out. Once you have it installed, you may also need to change the connection string in the test project Apps.config file.


On the Visual Studio side, after you open the solution and it does it’s thing, you should go to the Microsoft Visual Studio > Tools > NuGet Package Manager > Manage NuGet Packages for Solution… and after it opens and refreshes, if you see a Restore button in the upper right of the window, click it to download and install the 4 NuGet packages used (Dapper, DapperExtensions, MSTest.TestAdapter, and MSTest.TestFramework).


Additional Notes


  1. I use the Dapper and Dapper-Extensions NuGet packages.
  2. I have a MainRepository and a ChildRepository that work on the 2 corresponding tables (and their children).
  3. For this example, I really only needed the MainRepository but I had extra hours to kill so created the ChildRepository for fun.
    1. I’ve also created and implemented a ConnectionFactory in the ChildRepository just for fun.
  4. The test project will likely fail if you do a “Run All”. If you do that, try restoring and then running the “Ordered Tests > MainRepositoryTests” or “Ordered Tests > ChildRepositoryTests”. If you haven’t seen them before, these are Ordered Tests.

Comments

Post a Comment

Popular posts from this blog

A better mouse trap - issues with a Logitech Wireless Marathon Mouse M705

Image
The Wonderful Logitech Wireless Marathon Mouse M705 I picked up one of these for my work PC in March, 2017. I didn't know how I'd like it because the description talks about the "Hyper-fast scrolling" - a free-wheeling wheel. After it arrived and I installed it, I still wasn't sure how I liked it. You can spin the wheel and it just goes and goes. A co-worker of mine tried it and he instantly liked it. I have a similar looking Logitech mouse at home, but it's older and doesn't have the free-wheeling wheel. It has a "ratcheting" wheel like most mice. I found that, after a week or two of having the M705 at work, I was trying to use the hyper-fast scrolling at home and had got to where I decided I needed another M705 at home. I really like the way it handles! A new mouse in my house I ordered a second copy from Amazon  for about $20. Note that the Amazon price fluctuates. As I'm writing this, the price on Amazon is $27.42. Also note ...
Read more

Implementing IDisposable Properly

Image
The Confusion of IDisposable Maybe it's just me but I have a hard time figuring out the best way to implement IDisposable, let alone when to use the interface. I understand the basics, that you use IDisposable to manage releasing managed and unmanaged resources. But why do you need to use it? I have been looking online for information about IDisposable and there is a lot available, both from Microsoft as well as others. I have to say, though, that I spent some time this morning going through what I find to be the best information source I've seen: Pluralsight's  IDisposable Best Practices for C# Developers by Elton Stoneman You do have to have a Pluralsight account in order to watch this course but it was worth it to me. Note: Pluralsight offers a 10 day free trial on their website. You can also get a free 3 month trial to Pluralsight by joining the free Visual Studio Dev Essentials program. The program has a lot of other features as well, such as the GIT...
Read more

Driver Training - cleaning up unused USB drivers

Image
The following tale pertains to my Microsoft Windows 7 PC. I'm sure it's pretty much the same for a Windows 7 laptop. I don't know if any of this applies to Windows 8 or higher. Out with the old  As part of my adventure in installing the driver for my new Logitech Marathon Mouse M705  that I posted about in my previous post , I was made aware of a potential issue when installing a new USB device. I am not a real PC hardware guy, as you may surmise... I'm going to point to and refer to one of the many websites I came across while trying to figure out my mouse problems, this page from "How To Geek" at: https://www.howtogeek.com/howto/windows-vista/remove-old-drivers-after-upgrading-to-new-hardware/ Remnants Every time you install a new USB device that requires a driver (and what doesn't?), that driver is installed on the USB port you plugged the device into. If you later plug that same device into a different USB port on your same PC (or lapto...
Read more