divega

// What's new in C#
// Good places to start:
// - https://docs.microsoft.com/dotnet/csharp/whats-new/csharp-version-history#c-version-72
// - https://docs.microsoft.com/dotnet/csharp/whats-new/csharp-11

#region implicit and global usings (C# 10)
global using Microsoft.EntityFrameworkCore;
global using System.Collections;
using System;
#endregion

divega

using System;
using System.Linq;

namespace SortWithJoin
{
    class Program
    {
        static void Main(string[] args)
        {
            var keys = new [] { 5, 7, 3, 2, 1, 4, 6, 9, 8 };

divega

using System;
using System.Linq;
using Microsoft.Data.Sqlite;
using Microsoft.EntityFrameworkCore;
using Microsoft.Extensions.DependencyInjection;

namespace EnsureCreatedSqliteInMemory
{
    class Program
    {

divega

using Microsoft.EntityFrameworkCore;
using System.Linq;

namespace ConsoleApp33
{
    class Program
    {
        static void Main(string[] args)
        {
            using (var context = new MyContext())

divega

System.Data.Entity.SqlServer.SqlProviderServices.UseScopeIdentity = false;

divega

var query = db.People.Where(p => DbFunctions.Like(p.Name, "w%"));

divega

using System;
using System.Data.Entity;

namespace MyApplication
    public class MyContext: DbContext
    {
        public DbSet<Person> People { get; set; }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {

divega

using System.Data.Entity;
using System.Data.Entity.Infrastructure;

namespace MyApplication
{
    public class MyDbConfiguration : DbConfiguration
    {
        public MyDbConfiguration() : base()
        {
            this.SetModelStore(new DefaultDbModelStore(Directory.GetCurrentDirectory())); 

divega

using Microsoft.EntityFrameworkCore;

namespace TvpSampleApp
{
    public class MyContext : DbContext
    {
        public DbSet<Person> People { get; set; }

        protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
        {