All geek questions in one place

Does CQRS read ORM side or pure ADO.NET?

I am implementing my first project using the CQRS template, and now I need to decide how to implement the reading. The first approach that I am considering is to use ORM (Entity Framework / NHibernate or maybe someone can recommend me a faster ORM for this case?) And map the models to sql views. I initially thought about using indexed views, but I read an article about some performance issue (during recording) that made me abandon this idea ( http://sqlblog.com/blogs/alexander_kuznetsov/archive/2009/06/02/ be-ready-to-drop-your-indexed-view.aspx) The second approach that I am considering is to use pure ADO.NET (Data Read, etc.) and write sql yourself. Which approach is best in your opinion? or maybe there are some better?

+4
source share
3 answers

I would recommend using dapperdotnet or ormlite .

I used both tools extensively and returned to them every time I go to the outdated code to help request.

Both are very fast and provide enough abstraction from raw ADO.NET to make your code readable.

ORM , , , CQRS , ORM .

+3

. , Dapper, @boz, . , , , , MongoDB Raven ( ), .

, , , NoSQL, . !

+3

Go with NHibernate + Fluent the best combo I've ever used. Clean approach and very easy to use.

0
source

Source: https://habr.com/ru/post/1534046/

More articles:


All Articles