netdragoon

SELECT [x].[Id], 
       [x].[End], 
       [x].[Start]
FROM [Dates] AS [x]
WHERE [dbo].DATEDIFFDAY([x].[Start], [x].[End]) > 2

///////////////////////////////////////////////////////////////////////////

SELECT [x].[Id], 
       [x].[Start], 

netdragoon

var date2 = db.Date
  .Select(x => new
          {
              x.Id, 
              x.Start,
              x.End, 
              Diff = Database.DateDiffDay(x.Start, x.End)
          })
  .ToList();

netdragoon

var date1 = db.Date
  .Where(x => Database.DateDiffDay(x.Start, x.End) > 2)
  .ToList();

netdragoon

[DbFunction(FunctionName = "DATEDIFFDAY", Schema = "dbo")]
public static long DateDiffDay(DateTime start, DateTime end)
{
  return 0;
}

netdragoon

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER FUNCTION [dbo].[DATEDIFFDAY] 
(
	@start DateTime, @end DateTime
)
RETURNS bigint
AS

netdragoon

exec sp_executesql N'SELECT TOP(1) [e].[Id], [e].[Name], 
[e].[Id], [e].[AddressCity], 
[e].[AddressName], [e].[AddressNumber], [e].[AddressUf]
FROM [People] AS [e]
WHERE [e].[Id] = @__get_Item_0',N'@__get_Item_0 int',@__get_Item_0=1

netdragoon

People result = db.People.Find(1);

netdragoon

public class PeopleMap : IEntityTypeConfiguration<People>
{
    public void Configure(EntityTypeBuilder<People> builder)
    {
        builder.ToTable("People")
            .OwnsOne(x => x.Address, x =>
            {
                x.Property(a => a.City)
                .HasColumnName("AddressCity")
                .IsRequired().HasMaxLength(50);

netdragoon

public class People
{
    public int Id { get; set; }
    public string Name { get; set; }
    public Address Address { get; set; }
}

public class Address
{
    public string Name { get; set; }

netdragoon

SELECT TOP(1) [x].[Id], [x].[Description], [x].[Id], [x].[Amount], [x].[Price]
FROM [Products] AS [x]
WHERE [x].[Id] = 1