DataSpace

using DataSpace.Core;
using DataSpace.Query;

var workspace = new DatabaseWorkspace(SampleDatabase.Create());
var engine = new QueryEngine();

QueryResult sales = engine.Select(workspace.Document,
    "SELECT c.[Company], Count(o.[ID]) AS [Orders] FROM [Customers] AS c " +
    "INNER JOIN [Orders] AS o ON c.[ID] = o.[Customer ID] WHERE c.[Country] = [Country?] GROUP BY c.[Company]",
    new Dictionary<string, object?> { ["Country?"] = "UK" });
foreach (var row in sales.Records)
    Console.WriteLine($"{row["Company"]}: {row["Orders"]}");

var products = TableView.Open(workspace.Document, "Products", sortField: "Product Name");
IReadOnlyList<Record> firstPage = products.ReadPage(0, 50);   // only these rows are materialized

engine.Execute(workspace, "UPDATE [Products] SET [Unit Price] = [Unit Price] * 1.1 WHERE [Category] = 'Beverages'");
workspace.Undo();                                              // action queries are one undo step

using DataSpace.Core;
using DataSpace.Storage;

TableDefinition contacts = CsvCodec.Import("Contacts", "Name,Age\nAda,36\nAlan,41\n");  // types inferred
string csv = CsvCodec.Export(contacts.Fields, contacts.Records, new CsvOptions { Delimiter = ';' });

var workspace = new DatabaseWorkspace(new DatabaseDocument { Name = "Contacts" });
using var session = new WorkspaceSession(workspace, new FileWorkspaceStore("data/contacts.store"));
await session.InitializeAsync();                   // replaces the document if one is stored

workspace.Edit("Import contacts", document => document.Tables.Add(contacts));
if (session.IsDirty)
    await session.SaveAsync();                     // fails instead of overwriting a newer version

using DataSpace.Core;
using DataSpace.Rendering;
using SkiaSharp;

var document = SampleDatabase.Create();
var products = document.Table("Products");

using var datasheet = new DatasheetRenderer();
var state = new DatasheetViewState { ShowTotals = true, ReadOnly = true };
using var surface = SKSurface.Create(new SKImageInfo(900, 400));
datasheet.Draw(surface.Canvas, 900, 400, products.Fields, products.Records, state);
GridHit hit = datasheet.HitTest(products.Fields, products.Records.Count, state, 200, 60);   // Kind, Row, Column

var report = document.Reports.First(r => r.Name == "Customer Directory");
var source = document.Table(report.Source);
using var reports = new ReportRenderer();
File.WriteAllBytes("customer-directory.pdf", reports.ExportPdf(report, source.Fields, source.Records));

using DataSpace.Controls;
using DataSpace.Core;
using DataSpace.Storage;
using Microsoft.UI.Xaml;

var workspace = new DatabaseWorkspace(SampleDatabase.Create());
var session = new WorkspaceSession(workspace, new MemoryWorkspaceStore());
await session.InitializeAsync();
var view = new DatabaseWorkspaceView(workspace)
{
    StorageIsDirty = () => session.IsDirty,
    SaveDatabaseAsync = () => session.SaveAsync()
    // Inject ImportTextAsync and ExportFileAsync for your file-dialog or document-management integration.
};

var window = new Window { Title = "DataSpace", Content = view };
window.Activate();

// A single control without the shell:
var sheet = new DatasheetControl();
var products = workspace.Document.Table("Products");
sheet.SetData(products.Fields, products.Records, readOnly: true);