SSDS REST Library

NEW POST: Nice!

mattiasj — Fri, 14 Nov 2008 17:00:17 GMT

Fantastic work! Eagerly awaiting the version w/ join, orderby and take. Kinda hard to get started without them.

UPDATED WIKI: Home

dunnry — Wed, 12 Nov 2008 02:35:19 GMT

Description

This library uses the REST API against SQL Data Services and performs CRUD & Query operations. It features a powerful LINQ-based query and serialization model to make working with objects and SDS very simple.

Change Log:

20081011 Refresh Release

Updated the serialization mechanism to run in partial trust. This allows it to run inside Windows Azure projects.
Minor refactoring

20080904 Release

added support for blobs, concurrency, and parallelism

initial release

LINQ query syntax and strongly typed object support.
Simple predicates are translated to SQL Data Services Syntax automatically
Support for flexible properties in addition to strongly typed properties
Paging support
Support for multiple return types from query

Future Features

Add support for JOIN syntax, Take syntax, OrderBy syntax
Implement fully IQueryable model for the remaining features

Sample Syntax

var container = Context.OpenContainer("querytests");
var foo = new Foo { IsPublic = false, Name = "MyFoo", Size = 12 };
 
//insert it with unique id guid string
container.Insert(foo, Guid.NewGuid().ToString());
 
//notice the LINQ syntax on strong type "Foo"
var results = container.Query<Foo>(e => e.Entity.Size > 2);

This release also supports blobs via the SsdsBlobEntity both synchronously as well as async

MemoryStream mem = new MemoryStream();
//load memory stream
//...
//now upload it to service
using (SsdsBlobEntity blob = new SsdsBlobEntity(mem))
{
    blob.ContentDisposition = "violin.jpg";
    blob.MimeType = @"image/jpeg";
    blob.Id = Guid.NewGuid().ToString();
    var container = Context.OpenContainer("blobtests");
    container.Insert(blob);
}

Concurrency using If-Match and If-None-Match headers is supported as well.

var table = Context.OpenContainer("foo");
 
//create new foo
var foo = new Foo { IsPublic = false, Name = "Foo", Size = 10 };
string id = Guid.NewGuid().ToString();
table.Insert(foo, id);
 
//update entity if none match (different version)
SsdsEntity<Foo> entity = new SsdsEntity<Foo>();
entity.Entity = foo;
entity.Id = id;            
entity.Entity.Name = "Foo2";
 
table.Update(entity, ConcurrencyPattern.IfNoneMatch);

This release also supports parallelism to the SSDS service using the Parallel Extensions. This support is extensible to other techniques using extension methods.

var container = Context.OpenContainer("paging");
 
List<SsdsEntity<Foo>> entities = new List<SsdsEntity<Foo>>();
 
for (int i = 0; i < 10; i++)
{
    var foo = new Foo
    {
        IsPublic = false,
        Name = "Foo" + i,
        Size = i
    };
 
    entities.Add(new SsdsEntity<Foo>() { Entity = foo, Id = foo.Name });
}
 
Exception ex = null;
 
container.Insert<Foo>(entities, (ent, excep) =>
{
    ex = excep;
    return false;
});
 
if (ex != null)
{
    throw ex;
}

More information about this provider can be found in the related blog postings:

Serialization in SSDS
Working with Objects in SSDS Part 1
Working with Objects in SSDS Part 2
Working with Objects in SSDS Part 3

CREATED RELEASE: SDSRest - 20081011 Refresh (Nov 11, 2008)

Wed, 12 Nov 2008 02:25:59 GMT

UPDATED RELEASE: SSDS REST Library 9-4 Release (Sep 04, 2008)

Thu, 04 Sep 2008 20:21:28 GMT

RELEASED: SSDS REST Library 9-4 Release (Sep 04, 2008)

Thu, 04 Sep 2008 20:21:28 GMT

UPDATED WIKI: Home

dunnry — Thu, 04 Sep 2008 20:20:38 GMT

This library uses the REST api against SQL Server Data Services and performs CRUD & Query operations. It features a powerful LINQ-based query and serialization model to make working with objects and SSDS very simple.

This updated release on 9/4 features new support for blobs, concurrency, and parallelism in addition the already powerful LINQ query support over strongly typed objects.

var container = Context.OpenContainer("querytests");
var foo = new Foo { IsPublic = false, Name = "MyFoo", Size = 12 };
 
//insert it with unique id guid string
container.Insert(foo, Guid.NewGuid().ToString());
 
//notice the LINQ syntax on strong type "Foo"
var results = container.Query<Foo>(e => e.Entity.Size > 2);

This release also supports blobs via the SsdsBlobEntity both synchronously as well as async

MemoryStream mem = new MemoryStream();
//load memory stream
//...
//now upload it to service
using (SsdsBlobEntity blob = new SsdsBlobEntity(mem))
{
    blob.ContentDisposition = "violin.jpg";
    blob.MimeType = @"image/jpeg";
    blob.Id = Guid.NewGuid().ToString();
    var container = Context.OpenContainer("blobtests");
    container.Insert(blob);
}

Concurrency using If-Match and If-None-Match headers is supported as well.

var table = Context.OpenContainer("foo");
 
//create new foo
var foo = new Foo { IsPublic = false, Name = "Foo", Size = 10 };
string id = Guid.NewGuid().ToString();
table.Insert(foo, id);
 
//update entity if none match (different version)
SsdsEntity<Foo> entity = new SsdsEntity<Foo>();
entity.Entity = foo;
entity.Id = id;            
entity.Entity.Name = "Foo2";
 
table.Update(entity, ConcurrencyPattern.IfNoneMatch);

This release also supports parallelism to the SSDS service using the Parallel Extensions. This support is extensible to other techniques using extension methods.

var container = Context.OpenContainer("paging");
 
List<SsdsEntity<Foo>> entities = new List<SsdsEntity<Foo>>();
 
for (int i = 0; i < 10; i++)
{
    var foo = new Foo
    {
        IsPublic = false,
        Name = "Foo" + i,
        Size = i
    };
 
    entities.Add(new SsdsEntity<Foo>() { Entity = foo, Id = foo.Name });
}
 
Exception ex = null;
 
container.Insert<Foo>(entities, (ent, excep) =>
{
    ex = excep;
    return false;
});
 
if (ex != null)
{
    throw ex;
}

UPDATED RELEASE: SSDS REST Library 9-4 Release (Jul 02, 2008)

Thu, 04 Sep 2008 20:01:13 GMT

UPDATED WIKI: Home

dunnry — Wed, 02 Jul 2008 23:49:03 GMT

This library uses the REST api against SQL Server Data Services and performs CRUD operations. It features a powerful LINQ-based query and serialization model to make working with objects and SSDS very simple. More information about this provider can be found in the related blog postings:

Serialization in SSDS
Working with Objects in SSDS Part 1
Working with Objects in SSDS Part 2
Working with Objects in SSDS Part 3

CREATED RELEASE: SSDS REST Library (Jul 02, 2008)

Wed, 02 Jul 2008 23:46:43 GMT

CREATED RELEASE: SSDS REST Library (Jul 02, 2008)

Wed, 02 Jul 2008 23:42:06 GMT

UPDATED WIKI: Home

dunnry — Wed, 02 Jul 2008 23:35:33 GMT

This library uses the REST api against SQL Server Data Services and performs CRUD operations. It features a powerful query and serialization model to make working with objects and SSDS very simple. More information about this provider can be found in the related blog postings:

Serialization in SSDS
Working with Objects in SSDS Part 1
Working with Objects in SSDS Part 2
Working with Objects in SSDS Part 3