Which ORM should i be using for .Net in 2016 to talk to SQL server?
<p>Most of my server side experience is with nodeJS meteor or rails so i dont have a wealth of .Net knowledge yet. In rails its pretty easy to pick on ORM because ActiveRecord is the only game in town or so it seems. My approach was typically query everything you can using the ORM and if you cant pull it off then drop down to raw SQL. </p>

<p>However I am trying to read tutorials and lessons on querying my databases in .Net 4.5 or newer apps and I am confused on what the way of the future is. I see tutorials in the following</p>

<ul>
<li>Linq Lambda syntax</li>
<li>Linq Query syntax </li>
<li>Entity Framework </li>
</ul>

<p><strong>What is the suggested ORM for modern .net apps?</strong> It seems like i can do basic CRUD operations in all of the above. But will one be better suited for say joins across tables? Mind you I only ever plan to query against Microsoft SQL server databases for my .net solutions. </p>

<p>what really confused me is reading that EF replaced linq but then reading that EF also uses linq. So when i see an example to say select all columns i dont know if i am using a syntax of the past or future. Also just looking at code i cant tell if its linq or EF. I can tell if its query or lambda syntax though. </p>