C# Tuto Créer une appli .NET MAUI avec une base SQLite

 // Models/PasswordEntry.cs using SQLite;

namespace MyPasswordManager.Models { public class PasswordEntry { [PrimaryKey, AutoIncrement] public int Id { get; set; }

 
    [MaxLength(200), NotNull]
    public string Title { get; set; }

    [MaxLength(200)]
    public string Username { get; set; }

    [MaxLength(200)]
    public string Password { get; set; }

    public string Notes { get; set; }

    public DateTime CreatedAt { get; set; } = DateTime.UtcNow;
}
 

}

 // Services/DatabaseService.cs using SQLite; using MyPasswordManager.Models;

namespace MyPasswordManager.Services { public class DatabaseService { private readonly SQLiteAsyncConnection _db;

 
    public DatabaseService(string dbPath)
    {
        _db = new SQLiteAsyncConnection(dbPath);
    }

    public async Task InitAsync()
    {
        await _db.CreateTableAsync<PasswordEntry>();
    }

    public Task<List<PasswordEntry>> GetAllAsync() =>
        _db.Table<PasswordEntry>().OrderByDescending(p => p.CreatedAt).ToListAsync();

    public Task<PasswordEntry> GetAsync(int id) =>
        _db.Table<PasswordEntry>().Where(p => p.Id == id).FirstOrDefaultAsync();

    public async Task<int> SaveAsync(PasswordEntry entry)
    {
        if (entry.Id == 0)
            return await _db.InsertAsync(entry);
        else
            return await _db.UpdateAsync(entry);
    }

    public Task<int> DeleteAsync(PasswordEntry entry) =>
        _db.DeleteAsync(entry);
}
 

}

 // MauiProgram.cs using Microsoft.Maui.Storage; using MyPasswordManager.Services;

namespace MyPasswordManager;

public static class MauiProgram { public static MauiApp CreateMauiApp() { var builder = MauiApp.CreateBuilder(); builder .UseMauiApp() .ConfigureFonts(fonts => { fonts.AddFont("OpenSans-Regular.ttf", "OpenSansRegular"); fonts.AddFont("OpenSans-Semibold.ttf", "OpenSansSemibold"); });

 
    string dbPath = Path.Combine(FileSystem.AppDataDirectory, "passwords.db3");
    builder.Services.AddSingleton(new DatabaseService(dbPath));

    var app = builder.Build();

    // Initialisation de la base (création des tables)
    using var scope = app.Services.CreateScope();
    var db = scope.ServiceProvider.GetRequiredService<DatabaseService>();
    db.InitAsync().GetAwaiter().GetResult();

    return app;
}
 

}

 // Pages/PasswordListPage.xaml

    <CollectionView.ItemTemplate>   <SwipeView.RightItems>    </SwipeView.RightItems>          </CollectionView.ItemTemplate>

 // Pages/PasswordListPage.xaml.cs using MyPasswordManager.Models; using MyPasswordManager.Services;

namespace MyPasswordManager.Pages;

public partial class PasswordListPage : ContentPage { private readonly DatabaseService _db;

 
public PasswordListPage(DatabaseService db)
{
    InitializeComponent();
    _db = db;

    BtnAdd.Clicked += async (_, __) =>
    {
        await Navigation.PushAsync(new PasswordEditPage(_db));
    };

    EntriesView.SelectionChanged += async (_, e) =>
    {
        if (e.CurrentSelection?.FirstOrDefault() is PasswordEntry item)
        {
            await Navigation.PushAsync(new PasswordEditPage(_db, item.Id));
            EntriesView.SelectedItem = null;
        }
    };

    // Après une suppression via Swipe, on recharge.
    EntriesView.SwipeEnded += async (_, __) =>
    {
        await LoadAsync();
    };
}

protected override async void OnAppearing()
{
    base.OnAppearing();
    await LoadAsync();
}

private async Task LoadAsync()
{
    EntriesView.ItemsSource = await _db.GetAllAsync();
}
 

}

 using MyPasswordManager.Models; using MyPasswordManager.Services;

namespace MyPasswordManager.Pages;

public partial class PasswordEditPage : ContentPage { private readonly DatabaseService _db; private PasswordEntry _entry;

 
public PasswordEditPage(DatabaseService db, int id = 0)
{
    InitializeComponent();
    _db = db;
    _ = InitAsync(id);

    BtnSave.Clicked += async (_, __) =>
    {
        _entry.Title = TitleEntry.Text;
        _entry.Username = UserEntry.Text;
        _entry.Password = PassEntry.Text;
        _entry.Notes = NotesEditor.Text;

        await _db.SaveAsync(_entry);
        await Navigation.PopAsync();
    };

    BtnDelete.Clicked += async (_, __) =>
    {
        if (_entry?.Id > 0)
        {
            await _db.DeleteAsync(_entry);
            await Navigation.PopAsync();
        }
    };
}

private async Task InitAsync(int id)
{
    _entry = (id == 0) ? new PasswordEntry() : await _db.GetAsync(id);
    TitleEntry.Text = _entry.Title;
    UserEntry.Text = _entry.Username;
    PassEntry.Text = _entry.Password;
    NotesEditor.Text = _entry.Notes;
}
 

}

 // App.xaml.cs using MyPasswordManager.Pages;

public partial class App : Application { public App(PasswordListPage listPage) { InitializeComponent(); MainPage = new NavigationPage(listPage); } }

 builder.Services.AddTransient<Pages.PasswordListPage>();