sandcastle / stored

A light weight data store for storing entities with support for unit of work.

Stored

A light weight data store for storing entities with support for unit of work.

There are currently 2 supported providers in-memory (really fast) and Postgres.

Getting an entity

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
    var id = new Guid("3E137227-2BEF-451F-B392-482CDC2216B0");

    var car = session.Get<Car>(id);
}

Saving an entity

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
    session.Create(new Car { Make = "Aston Martin", Model = "DB9 Volante" });
    session.Commit();
}

Modifying an entity

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
    var car = session.Get<Car>(carId);
	car.Model = "Mustang";

    session.Modify(car);
    session.Commit();
}

Deleting an entity

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
    var car = session.Get<Car>(carId);

    session.Delete(car);
    session.Commit();
}

Querying for entities

I haven't had time to build a Linq provider yet - feel free to send a pull request for one.

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
	session.Create(new Car { Make = "Toyota", Model = "Rav4" });
    session.Create(new Car { Make = "Aston Martin", Model = "DB9 Volante" });
    session.Create(new Car { Make = "Toyota", Model = "Corolla" });
    session.Commit();

    var items = session.Query<Car>()
                .Where(x => x.Make).Equal("Toyota")
                .ToList();
}

Ordering entities

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
	session.Create(new Car { Make = "Toyota", Model = "Rav4" });
    session.Create(new Car { Make = "Aston Martin", Model = "DB9 Volante" });
    session.Create(new Car { Make = "Toyota", Model = "Corolla" });
    session.Commit();

    var item = session.Query<Car>()
                      .OrderBy(x => x.Make)
                      .ToList();
}

Bulk create

var store = new PostgresStore(connectionString);

using (var session = store.CreateSession())
{
    var items = new List<Car>
    {
        new Car { Make = "Aston Martin", Model = "DB9 Volante" },
        new Car { Make = "Toyota", Model = "Rav4" }
    };

    // does not buffer in unit of work
    session.Advanced.BulkCreate(items);
}

Inspiration

Inspriation from this project has come from Raven DB and Biggy.

stored's Issues

Add In(object[]) filter

Add a filter called "In" that restricts based on a set.