using Detached.Annotations;

using Detached.Mappers.EntityFramework;

using Microsoft.Data.Sqlite;

using Microsoft.EntityFrameworkCore;

using System.ComponentModel.DataAnnotations;

using System.ComponentModel.DataAnnotations.Schema;

using System.Collections.Generic;

using System.Linq;

using System.Threading.Tasks;

using System;

​

class Program

{

    // this example shows how to use detached to create/update an entity using an anonymous type 

    // as DTO.

    static async Task Main(string[] args)

    {

        Console.WriteLine("- create entity");

        using (DetachedDbContext context = new DetachedDbContext())

        {

            // create the sqlite db.

            context.Database.EnsureCreated();

​

            context.Users.Add(new User { Id = 1, Name = "usr1" });

            context.Users.Add(new User { Id = 2, Name = "usr2" });

            context.SaveChanges();

​

            List<UserDto> users = new List<UserDto>();

            users.Add(new UserDto{ Id = 1, Name = "usr1_modified" });

            users.Add(new UserDto{ Id = 2, Name = "usr2_modified" });

            var entities = await context.MapAsync<User>(users);

​

            await context.SaveChangesAsync();

        }

​

        // using is not necessary, but used to simulate different request in a stateless app, like a rest API.

        using (DetachedDbContext context = new DetachedDbContext())

        {

            User persisted = await context.Users

                .Where(i => i.Id == 1)

                .FirstOrDefaultAsync();

​

            // check that all created values are OK.

            Assert(persisted != null, "persisted not null");

            Assert(persisted.Name == "usr1_modified", "user name was changed.");

        }

​

        Console.WriteLine("[test ended]");

        Console.ReadKey();

    }

​

    static void Assert(bool condition, string label)

    {

        if (condition)

            Console.WriteLine($"{label}: ok");

        else

            Console.WriteLine($"{label}: error!");

    }

}

​

public class DetachedDbContext : DbContext

{

    static SqliteConnection _connection;

​

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)

    {

        if (_connection == null)

        {

            _connection = new SqliteConnection($"DataSource=file:{Guid.NewGuid()}?mode=memory&cache=shared");

            _connection.Open();

        }

​

        optionsBuilder.UseSqlite(_connection)

                      .UseMapping();

    }

​

    public DbSet<User> Users { get; set; }

}

​

public class User

{

    [Key]

    [DatabaseGenerated(DatabaseGeneratedOption.None)]

    public virtual int Id { get; set; }

​

    public virtual string Name { get; set; }

​

    public virtual DateTime DateOfBirth { get; set; }

}

​

public class UserDto

{

    public virtual int Id { get; set; }

​

    public virtual string Name { get; set; }

​

    public virtual DateTime DateOfBirth { get; set; }

}