MicroORM Examples

Repository to store the examples of experimenting/playing with Micro ORMs in .Net

Goal

Be able to use a Micro ORM for the applications planned to build in 2015. For that I need to be able to

• create, read, update and delete rows (CRUD) in a SQL Server database ✔️
• use fulltext & semantic search to find the requested data ✔️
• use transactions to ensure data integrity ✔️
• explain patterns and their trade offs
• ensure the quality of the application using automated tests
• have an example project that uses all of these points

Links

Micro ORM

• Dapper ✔️
• Massive ✔️
• FluentData ❌
• PetaPoco ✔️
• Insight.Database ❌
• MicroLite ORM ❌
• Symbiotic ❌
• Top 20 NuGet packages for micro-orm ✔️

Theory

• Small is Beautiful - .NET Micro ORMs ✔️
• What ORMs have taught me: just learn SQL
• Micro-ORMs for .NET Compared – Part 1 ✔️
• Choosing an ORM strategy ✔️
• What are some of the benefits of a “Micro-ORM”? ✔️
• 5 reasons not to use a micro ORM ✔️

Courses / Examples

• .NET Micro ORMs ✔️

Problems / Attention

• You may receive incorrect values when using SCOPE_IDENTITY() and @@IDENTITY ‼️

Full text search

• Querying SQL Server Using Full-Text Search ✔️
• Query with Full-Text Search ✔️
• StackOverflow: Full text search in sql server ✔️
• Semantic Search (SQL Server) ✔️
• Find Similar or Related Documents with SEMANTICSIMILARITYTABLE ✔️

Other

• EMOJI CHEAT SHEET