Wilson.ORQuery

UPDATED WIKI: Home

mxmissile — Mon, 19 May 2008 13:36:06 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>.With(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
builder.AddOrder(OrderBy.For<Product>("title"));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

Warning
This release is early and experimental, probably not safe in a production environment. Also the query strings generated have not been tested with anything other than SQL Server 2000/2005.

WilsonOR.Wrapper Integration
Add something like this to Data_T.cs (http://code.google.com/p/wilsonormapper/source/browse/trunk/WilsonORWrapper/WilsonORWrapper/Services/Data_T.cs) or even better, inherit from Data_T.cs.

protected static QueryBuilder<T> GetQueryBuilder()
{
     return QueryBuilder<T>.With(DataProvider.ObjectSpace.QueryHelper);
}
 
public static Collection<T> Retrieve(QueryBuilder<T> builder)
{
      return InnerRetrieveMany(builder.GetObjectQuery(),false);
}

then utilized like so...

public class ProductRepository : Data<Product>
{
     public static IList<Product> RetrieveManyByPrice(decimal price)
     {
          QueryBuilder builder = GetQueryBuilder();
          builder.Add(Expression.Equals("price",price);
          return Retrieve(builder);
     }
}

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:32:30 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>.With(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
builder.AddOrder(OrderBy.For<Product>("title"));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

Warning
This release is early and experimental, probably not safe in a production environment.

WilsonOR.Wrapper Integration
Add something like this to Data_T.cs (http://code.google.com/p/wilsonormapper/source/browse/trunk/WilsonORWrapper/WilsonORWrapper/Services/Data_T.cs) or even better, inherit from Data_T.cs.

protected static QueryBuilder<T> GetQueryBuilder()
{
     return QueryBuilder<T>.With(DataProvider.ObjectSpace.QueryHelper);
}
 
public static Collection<T> Retrieve(QueryBuilder<T> builder)
{
      return InnerRetrieveMany(builder.GetObjectQuery(),false);
}

then utilized like so...

public class ProductRepository : Data<Product>
{
     public static IList<Product> RetrieveManyByPrice(decimal price)
     {
          QueryBuilder builder = GetQueryBuilder();
          builder.Add(Expression.Equals("price",price);
          return Retrieve(builder);
     }
}

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:29:31 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>.With(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
builder.AddOrder(OrderBy.For<Product>("title"));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

Warning
This release is early and experimental, probably not safe in a production environment.

WilsonOR.Wrapper Integration
Add something like this to DataT.cs (http://code.google.com/p/wilsonormapper/source/browse/trunk/WilsonORWrapper/WilsonORWrapper/Services/DataT.cs)

protected static QueryBuilder<T> GetQueryBuilder()
{
     return QueryBuilder<T>.With(DataProvider.ObjectSpace.QueryHelper);
}
 
public static Collection<T> Retrieve(QueryBuilder<T> builder)
{
      return InnerRetrieveMany(builder.GetObjectQuery(),false);
}

then utilized like so...

public class ProductRepository : Data<Product>
{
     public static IList<Product> RetrieveManyByPrice(decimal price)
     {
          QueryBuilder builder = GetQueryBuilder();
          builder.Add(Expression.Equals("price",price);
          return Retrieve(builder);
     }
}

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:28:36 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>.With(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
builder.AddOrder(OrderBy.For<Product>("title"));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

Warning
This release is early and experimental, probably not safe in a production environment.

WilsonOR.Wrapper Integration
Add something like this to DataT.cs : http://code.google.com/p/wilsonormapper/source/browse/trunk/WilsonORWrapper/WilsonORWrapper/Services/DataT.cs

protected static QueryBuilder<T> GetQueryBuilder()
{
     return QueryBuilder<T>.With(DataProvider.ObjectSpace.QueryHelper);
}
 
public static Collection<T> Retrieve(QueryBuilder<T> builder)
{
      return InnerRetrieveMany(builder.GetObjectQuery(),false);
}

then utilized it like so...

public class ProductRepository : Data<Product>
{
     public static IList<Product> RetrieveManyByPrice(decimal price)
     {
          QueryBuilder builder = GetQueryBuilder();
          builder.Add(Expression.Equals("price",price);
          return Retrieve(builder);
     }
}

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:27:56 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>.With(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
builder.AddOrder(OrderBy.For<Product>("title"));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

protected static QueryBuilder<T> GetQueryBuilder()
{
     return QueryBuilder<T>.With(DataProvider.ObjectSpace.QueryHelper);
}
 
public static Collection<T> Retrieve(QueryBuilder<T> builder)
{
      return InnerRetrieveMany(builder.GetObjectQuery(),false);
}

then utilized it like so...

public class ProductRepository : Data<Product>
{
     public static IList<Product> RetrieveByPrice(decimal price)
     {
          QueryBuilder builder = GetQueryBuilder();
          builder.Add(Expression.Equals("price",price);
          return Retrieve(builder);
     }
}

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:11:34 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>.With(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
builder.AddOrder(OrderBy.For<Product>("title"));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

Warning
This release is early and experimental, probably not safe in a production environment.

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:08:17 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

Warning
This release is early and experimental, probably not safe in a production environment.

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:07:16 GMT

Project Description
Wilson.ORMapper query framework similar to nHibernate's DetachedCriteria.

Very Simple Example:

QueryBuilder<Product> builder = new QueryBuilder<Product>(objectSpace.QueryHelper);

builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));

string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

This release is early and experimental, probably not safe in a production environment.

Simple Code Sample

QueryBuilder<Product> builder = new QueryBuilder<Product>(objectSpace.QueryHelper);
 
builder.Add(Expression.GreaterThan("price",10));
builder.Add(Expression.Equals("visible",true));
 
string query = builder.GetObjectQuery();
return objectSpace.GetObjectSet(query);

UPDATED WIKI: Home

mxmissile — Fri, 16 May 2008 21:03:15 GMT

Source code checked in

mxmissile — Fri, 16 May 2008 20:55:16 GMT