Bilagor

using Microsoft.Extensions.Configuration;

// Läs configuration
var config = new ConfigurationBuilder()
    .SetBasePath(Directory.GetCurrentDirectory())
    .AddJsonFile("appsettings.json")
    .Build();

// Hämta connection string
string connectionString = config.GetConnectionString("SQLite")!;

// Hämta specifik setting
string provider = config["DatabaseSettings:Provider"]!;

// Program.cs eller Startup.cs
services.AddDbContext<AppDbContext>(options =>
    options.UseSqlite(Configuration.GetConnectionString("SQLite")));

// CREATE
using (var context = new AppDbContext())
{
    var entity = new Customer { Name = "Test", Email = "test@example.com" };
    context.Customers.Add(entity);
    context.SaveChanges();
}

// READ - Alla
using (var context = new AppDbContext())
{
    var customers = context.Customers.ToList();
}

// READ - Filtrerad
using (var context = new AppDbContext())
{
    var customers = context.Customers
        .Where(c => c.Email.EndsWith("@example.com"))
        .OrderBy(c => c.Name)
        .ToList();
}

// READ - Med relationer
using (var context = new AppDbContext())
{
    var customers = context.Customers
        .Include(c => c.Orders)
        .ThenInclude(o => o.OrderItems)
        .ToList();
}

// UPDATE
using (var context = new AppDbContext())
{
    var customer = context.Customers.Find(1);
    if (customer != null)
    {
        customer.Email = "newemail@example.com";
        context.SaveChanges();
    }
}

// DELETE
using (var context = new AppDbContext())
{
    var customer = context.Customers.Find(1);
    if (customer != null)
    {
        context.Customers.Remove(customer);
        context.SaveChanges();
    }
}

// Setup
var client = new MongoClient("mongodb://localhost:27017");
var database = client.GetDatabase("myapp");
var collection = database.GetCollection<Customer>("customers");

// CREATE
var customer = new Customer { Name = "Test", Email = "test@example.com" };
await collection.InsertOneAsync(customer);

// READ - Alla
var customers = await collection.Find(_ => true).ToListAsync();

// READ - Filtrerad
var customers = await collection
    .Find(c => c.Email.EndsWith("@example.com"))
    .SortBy(c => c.Name)
    .ToListAsync();

// READ - Med Filter Builder
var filter = Builders<Customer>.Filter.Eq(c => c.Email, "test@example.com");
var customer = await collection.Find(filter).FirstOrDefaultAsync();

// UPDATE
var filter = Builders<Customer>.Filter.Eq(c => c.Id, customerId);
var update = Builders<Customer>.Update.Set(c => c.Email, "newemail@example.com");
await collection.UpdateOneAsync(filter, update);

// UPDATE - Lägg till i array
var addUpdate = Builders<Customer>.Update.Push(c => c.Tags, "newtag");
await collection.UpdateOneAsync(filter, addUpdate);

// DELETE
var filter = Builders<Customer>.Filter.Eq(c => c.Id, customerId);
await collection.DeleteOneAsync(filter);