QueryFramework - Build and execute sql queries in an object oriented way

UPDATED RELEASE: QueryFramework v0.1 (oct 05, 2007)

Tue, 18 Mar 2008 09:54:07 GMT

*Introduction*
QueryFramework is created with four main goals in mind:

1. Create sql queries in an object oriented way.
2. Create sql queries with independence of the database dialect used.
3. Execute queries with abstraction of the database used.
4. Create a simple implementation of the ActiveRecord pattern with a lot of flexibility to mix simple save/update/load objects with common sql queries.

*First release of QueryFramework*
This is the first release of the QueryFramework but we have been using it already for months so it's quite stable.
Any comments and new features are welcome.

For examples and documentation, visit QueryFramework home page:
[url:http://www.codeplex.com/queryframework]

Yours,

Richard Chamorro
QueryFramework coordinator
[url:http://www.avanzis.com]

NEW POST: How to use OR operator in WhereClause?

Shyamsunder — Mon, 10 Mar 2008 11:09:45 GMT

How to use OR Operator in Where Clause?

e.g

(CustomerID="33" OR CustomerID="###")

And how to use multiple statements in WhereClause with different operators??

etc

Source code checked in

KingGudu — Thu, 18 Oct 2007 09:47:48 GMT

Updated MySqlDataProvider to use MySql Connector 5.0.8.1 and added the connector DLL file as reference

Source code checked in

KingGudu — Wed, 17 Oct 2007 13:47:44 GMT

Changed FindOne Method signature to be consistent with other methods like FindAll

Source code checked in

KingGudu — Wed, 17 Oct 2007 11:49:46 GMT

Added BeforeDeleteMethod(); Changed default connection string name for QueryObjects

CREATED ISSUE: Add BeforeDelete to ActiveRecordBase

KingGudu — Wed, 17 Oct 2007 11:25:44 GMT

Add a virtual method that is called before an object is deleted.

UPDATED WIKI: QueryFramework

KingGudu — Wed, 17 Oct 2007 11:23:00 GMT

QueryFramework

The main function of the QueryFramework is to configure all the components to use a database dialect. A dialect is the sql language variation used by a database for queries.

For example, if you want to get the 5 first articles of the articles table, the sentence in Sql Server is:

SELECT TOP 5 * FROM Articles;

But the sentence is different in MySql:

SELECT * FROM Articles LIMIT 5;

This differences forces developers to have database types and their different dialects in mind when creating their queries. QueryFramework tries to simplify just configuring the dialect one time at application start.

Source code checked in

KingGudu — Wed, 10 Oct 2007 16:40:13 GMT

CREATED ISSUE: Implement provider pattern for QueryProcessor and QueryExecutor

KingGudu — Wed, 10 Oct 2007 10:38:08 GMT

Implement the provider pattern for QueryProcessor of QueryBuilder and QueryExecutor so the queryframework can be extended.

CREATED TASK: Translate comments from Spanish to English

KingGudu — Wed, 10 Oct 2007 10:06:54 GMT

English language allow more developers to understand comments.

CREATED TASK: Sign assembly

KingGudu — Wed, 10 Oct 2007 10:05:29 GMT

An assembly must be signed to be reference by other signed assemblies.

Source code checked in

KingGudu — Mon, 08 Oct 2007 08:36:28 GMT

Updated to v0.2

UPDATED RELEASE: QueryFramework v0.2

Mon, 08 Oct 2007 07:40:03 GMT

Bugfixes and improvements from v0.1

*New features*
* Added Insert method to the Order collection.

UPDATED RELEASE: QueryFramework v0.2

Mon, 08 Oct 2007 07:39:48 GMT

Bugfixes and improvements from v0.1

*New features*
* Added Insert method to the Order collection.

Source code checked in

KingGudu — Mon, 08 Oct 2007 07:36:05 GMT

Added Insert Method to the Order Collection

RELEASED: QueryFramework v0.1 (Oct 05, 2007)

Fri, 05 Oct 2007 08:58:10 GMT

UPDATED RELEASE: QueryFramework v0.1 (oct 05, 2007)

Fri, 05 Oct 2007 08:58:10 GMT

UPDATED WIKI: Home

KingGudu — Fri, 05 Oct 2007 08:56:36 GMT

Project Description
A simple framework for building sql statements in an object oriented way, executing sql statements with database independency and providing simple object persistence.

Introduction
This framework is created with four main goals in mind:

Create sql queries in an object oriented way.
Create sql queries with independence of the database dialect used.
Execute queries with independence of the database used.
Create a simple implementation of the ActiveRecord pattern with a lot of flexibility to mix simple save/update/load objects with common sql queries.

Main components

QueryFramework - Configures QueryFramework.
QueryBuilder - Helps you build sql quieries in an object oriented way that will work in any database.
QueryExecutor - Gives you a layer of abstraction to execute queries against any database.
QueryObjects - A simple implementation of the ActiveRecord pattern but with a lot of flexibility.

Where to go from here

Tutorial
Examples

What can you do with the QueryFramework?

Here are some simple examples using QueryFramework, please visite Examples for more code snippets.

QueryBuilder example
Here is a simple example of what you can do with QueryBuilder:

SelectBuilder sb = new SelectBuilder();
sb.Select.Fields.Add("ArticleId");
sb.Select.Fields.Add("Name");
sb.From.TableName = "Articles";
sb.Where.Filters.Add("Active = 1");
 
Console.Write(sb.ToString());
 
// output: "SELECT ArticleId,Name FROM [Articles] WHERE (Active = 1)";

Visit QueryBuilder Examples to see more advanced uses of QueryBuilder.

QueryExecutor example
Here is a simple example of what you can do with QueryExecutor:

DataTable articles = Database.ExecuteDataTable(connectionString, CommandType.Text, "SELECT * FROM Articles");

QueryObject example
Here is a simple example of what you can do with QueryObjects:

First you have to decorate class to persist with some attributes.

    [ActiveRecord("Referees")]
    public class Referee : ActiveRecordBase<Referee>
    {
        private String code;
        private String name;
 
        public Referee() : base()
        {
        }
 
        public Referee(Session session)
            : base(session)
        {
        }
        
 
        [PrimaryKey(PrimaryKeyType.Assigned)]
        public String Code
        {
            get { return code; }
            set { code = value; }
        }
 
        [Property]
        public String Name
        {
            get { return name; }
            set { name = value; }
        }
    }

Then you can load, save and update it

Referee savedReferee = new Referee();
savedReferee.Code = "REF";
savedReferee.Name = "Referee REF";
savedReferee.Save();
 
Referee loadedReferee = new Referee();            
loadedReferee .Load("XXX");
Console.Write(loadedReferee.Name);
// output: Referee REF;

Contributions
All contributions are welcome, specially fixing bugs, documenting, adding support for new databases and suggesting new features.

CREATED RELEASE: QueryFramework v0.1 (oct 05, 2007)

Fri, 05 Oct 2007 08:55:19 GMT

*Introduction*
QueryFramework is created with four main goals in mind:

1. Create sql queries in an object oriented way.
2. Create sql queries with independence of the database dialect used.
3. Execute queries with abstraction of the database used.
4. Create a simple implementation of the ActiveRecord pattern with a lot of flexibility to mix simple save/update/load objects with common sql queries.

*First release of QueryFramework*
This is the first release of the QueryFramework but we have been using it already for months so it's quite stable.
Any comments and new features are welcome.

Richard Chamorro
QueryFramework coodinator
[url:http://www.avanzis.com]

UPDATED WIKI: Examples

KingGudu — Fri, 05 Oct 2007 08:52:55 GMT

QueryFramework Examples

Looking at someone else code is a good way to learn how something works so we will put here many examples.

Configuration Examples
QueryBuilder Examples
QueryExecutor Examples
QueryObjects Examples