SSDS REST Library

NEW POST: Adding metadata to the blob

jainswati — Tue, 14 Apr 2009 14:13:37 GMT

Hi,

First of all thanks for the wonderful work. Your library has made it very easy for our team. I do have a question however. Now, in your examples related to adding a blob to Azure storage, you are adding things like id, content disposition etc. I want to add some metadata to the blob. Like for e.g. in the microsoft examples, I could do the following -

BlobProperties properties = new BlobProperties(string.Format(CultureInfo.InvariantCulture, "image_{0}", id));
NameValueCollection metadata = new NameValueCollection();
properties.Metadata = metadata;

With your library, I can have a SsdsBlob entity and assign properties. But, how to assign metadata like username or date entered or expiry date etc.

NEW POST: Querying on Strings - not supported?

RajeshKris — Wed, 11 Mar 2009 16:46:48 GMT

Jamie,
Thanks for your reply. My bad, I am using the SSDS client in my VB.net program. When I use the following, it throws a not supported error

Dim results = container.Query(Of SampleEntity)(Function(X As SsdsEntity(Of SampleEntity)) X.Entity.StringField = "1234")

Any help would be greatly appreciated

NEW POST: Bug: CreateAuthority() doesn't return the URI of the created authority

jamiet — Tue, 03 Feb 2009 21:53:57 GMT

Hi,
Just reporting a small bug.
CreateAuthority() doesn't return the URI of the created authority as it says it should:

/// <summary>
/// Creates an authority with given name.
/// </summary>
/// <param name="name">The authority name.</param>
/// <returns>The URI of the created authority.</returns>
public string CreateAuthority(string name)
{
SsdsRestFacade facade = this.CreateFacade(true);
var authority = new XElement(Constants.ns + "Authority",
new XElement(Constants.ns + "Id", name)
);

return facade.Insert(authority.ToString());
}

Regards
Jamie

NEW POST: No AuthorityExists() method??

jamiet — Mon, 02 Feb 2009 17:01:57 GMT

I am using the following code along with the SSDS REST Librayr:
if (!ctx.ContainerExists("containerName")){
ctx.CreateContainer("containerName");
}

However, I'm not able to do this:
if (!ctx.AuthorityExists("authorityName")){
ctx.CreateAuthority("authorityName");
}
because there is no AuthorityExists() method.

I imagine this is because when you, Ryan, first produced the library it was not possible to query for a list of authorities. However, it is now, so can I request that you add this method? I realise its pretty easy to do ourselves but it would be handy to see it added to the source here so that everyone can take advantage of it.

Thanks
Jamie

NEW POST: Querying on Strings - not supported?

jamiet — Mon, 02 Feb 2009 16:57:36 GMT

Rajesh,
Try this:
var results = container.Query<Foo>(e => e.Entity.Name =="My Foo");

Common mistake for a VB person - believe me, I've made the same mistake plenty of times.

-Jamie

NEW POST: Querying on Strings - not supported?

RajeshKris — Sat, 24 Jan 2009 14:24:13 GMT

I'd like to first appreciate you for such a great framework. You just made my day.

From you sample code, the following works
var results = container.Query<Foo>(e => e.Entity.Size > 2);

However the following is not supported
var results = container.Query<Foo>(e => e.Entity.Name ="My Foo");

Since I am new to Linq Expression tree plus a VB.NET guy, I am unable to alter your code to make this work. Any suggesstions/ideas would be appreciated.

I could query all the entities and do a client side filteration, but that is not a scalable option.

-Thanks again.

NEW POST: Nice!

mattiasj — Fri, 14 Nov 2008 20: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 05: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

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

Thu, 04 Sep 2008 23:21:28 GMT

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

Thu, 04 Sep 2008 23:21:28 GMT

UPDATED WIKI: Home

dunnry — Thu, 04 Sep 2008 23: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 23:01:13 GMT

UPDATED WIKI: Home

dunnry — Thu, 03 Jul 2008 02: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)

Thu, 03 Jul 2008 02:46:43 GMT

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

Thu, 03 Jul 2008 02:42:06 GMT

UPDATED WIKI: Home

dunnry — Thu, 03 Jul 2008 02: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