Entity Framework 7 (EF7) Preview 5 has shipped with support for Table-per-Concrete type (TPC) mapping. This blog post will focus on TPC. There are several other enhancements included in Preview 5, such as:
Read the full list of EF7 Preview 5 enhancements.
DECLARE @Varsort varchar(50)
DECLARE @Varsort1 varchar(50)
SET @Varsort=''
SET @Varsort1='BusinessEntityID'
SELECT BusinessEntityID, FirstName, LastName
FROM Testoffset
ORDER BY case when @Varsort='Firstname'then Firstname End ASC,
case when @Varsort1= 'BusinessEntityID'then BusinessEntityID End ASC
OFFSET 3 ROWS
FETCH First 3 ROWS only
<connectionStrings>
<clear/>
<add
name="ProductContext"
connectionString="Data Source=(local);Initial Catalog=testdb2012;Integrated Security = true"
providerName="System.Data.SqlClient"
/>
</connectionStrings>
public class ProductContext : DbContext