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.

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
10. @jkuemerle / www.kuemerle.com http://www.veracode.com/resources/state-of-software-security SQL INJECTION TREND Percentage of Applications Affected
14. https://www.flickr.com/photos/pliffgrieff/3684652349/
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”
20. https://www.flickr.com/photos/rjacklin/436491997/
21. https://www.flickr.com/photos/97477873@N00/20156074485/
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