none
Which one is the Fastest ORM avaialble for .NET app RRS feed

All replies

  • There are plenty of comparisons available online that you can google for. But the reality is that the only way to know which is fastest for you is to try them. Each ORM makes compromises in some areas to gain performance in others. It completely depends upon your data model, how you're loading data and whatnot as to which one is the fastest. For example, if you're pulling single tables then nothing is faster than ADO.NET directly. There would be no reason to use an ORM. But if are pulling lots of related tables and you're using eager loading then 1 ORM may be faster than another that is optimized for lazy loading. There simply is no good metric outside of testing this yourself.

    Thursday, January 19, 2017 2:56 PM
  • Also that's like asking "What's the world's fastest car?", when you should normally ask "What's the best car for me?"

    David


    Microsoft Technology Center - Dallas

    My Blog

    Thursday, January 19, 2017 4:04 PM
  • Frans Bouma has some measurements here: https://github.com/FransBouma/RawDataAccessBencher


    Please mark as answer, if this was it. Visit my SQL Server Compact blog http://erikej.blogspot.com

    Sunday, January 22, 2017 4:44 PM
  • Have you tried vega? Vega is fastest .net ORM with Enterprise features.


    Thanks,
    Ritesh


    • Edited by aadreja Tuesday, January 23, 2018 7:21 AM
    Tuesday, January 23, 2018 7:21 AM
  • www.SQLPLUS.net is fastest by a wide margin and is the future of ORM's
    Friday, November 15, 2019 6:01 AM
  • www.SQLPLUS.net is fastest by a wide margin and is the future of ORM's
    Where does it say it's an ORM?
    Friday, November 15, 2019 8:26 AM