public static ReservarionSystemDbContext GetDatabaseInMemory()
        {
            var InMemoryConnectionString = "DataSource=:memory:";

            var connection = new SqliteConnection(InMemoryConnectionString);


            connection.Open();



            var options = new DbContextOptionsBuilder <ReservarionSystemDbContext>()
                          .UseSqlite(connection)
                          .Options;
            var context = new ReservarionSystemDbContext(options);


            context.Database.EnsureDeleted();

            context.Database.EnsureCreated();

            DataSeeder.CreateContactType(context);
            DataSeeder.CreateContacts(context);
            DataSeeder.CreateReservations(context);

            return(context);
        }