Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Lightweight Data Access in .NET

Lightweight Data Access in .NET

NHibernate, Entity Framework and a whole host of other complex ORMs are available for .NET but what if you just need to move data from a database to an application quickly and simply? In this session we will review two of the lighter weight data access technologies: Simple.Data and Dapper.
If you don't need every single feature under the sun, these may be just the data access solution you are looking for. See how you can build well architected and secure applications with these technologies without having to spend valuable development time implementing a complex solution to a simple problem.

Fec6a312fc2dff26897c287bd941cdd8?s=128

Joe Kuemerle

July 13, 2018
Tweet

Transcript

  1. Lightweight Data Access in .NET

  2. TITANIUM SPONSORS Platinum Sponsors Gold Sponsors

  3. Joe Kuemerle • Security focused developer in a broad range

    of technologies • Specialize in data topics, application and data security, coding best practices and regulatory compliance • Presenter at community, regional and national events. https://proftalon.smugmug.com/Hogwarts/2914-summer/i-v4tSLNL/A
  4. techbash.com

  5. https://www.flickr.com/photos/lynnfriedman/35026121905/

  6. https://www.flickr.com/photos/glenz_collection/5844980836/

  7. https://www.flickr.com/photos/devincp/4385288899/

  8. https://github.com/StackExchange/Dapper

  9. None
  10. @jkuemerle / www.kuemerle.com http://www.veracode.com/resources/state-of-software-security SQL INJECTION TREND Percentage of Applications

    Affected
  11. None
  12. None
  13. None
  14. https://www.flickr.com/photos/pliffgrieff/3684652349/

  15. None
  16. Naming Conventions – “Fluid” 1. Start with database 2. Optional

    Schema 3. Primary Table 4. Method 5. If “By” then column specifier(s) or Optional Additional Criteria
  17. Naming Conventions – “Indexer”

  18. None
  19. None
  20. https://www.flickr.com/photos/rjacklin/436491997/

  21. https://www.flickr.com/photos/97477873@N00/20156074485/

  22. None
  23. None
  24. https://pixabay.com/en/rock-cliff-high-tableau-mountain-731140/

  25. https://www.flickr.com/photos/emilybean/3260547933/

  26. https://pixabay.com/en/traffic-light-vector-traffic-road-2731969/

  27. Resources • Simple.Data • https://github.com/markrendle/Simple.Data • https://github.com/RendleLabs/Simple.Data.Core • http://simplefx.org/simpledata/docs/ •

    DotNetRocks Simple.Data.Core with Mark Rendle: https://dotnetrocks.com/?show=1347 • Dapper • https://github.com/StackExchange/Dapper • http://dapper-tutorial.net/ • https://visualstudiomagazine.com/articles/2018/03/19/dapper-orm.aspx