Posts

Showing posts from September, 2017

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

My Blog Hiatus

Image
I can't believe it's been almost 2 months since I posted anything. Where does the time go? It's probably been even longer since I did a photography post... I've been busy at work and have kind of neglected this blog. I've actually been kind of working on a blog sort of thing at work - a Tech Tip that I send out. I'm going to start posting them here too since they apply. Here's the first one: