NBear

UPDATED WIKI: Home

teddycn — Mon, 14 Apr 2008 01:48:45 GMT

News Feeds

Introduction

NBearLite : NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. NBearLite is the new Core of the next generation of NBear V4 Framework, but can also be used seperately.

NBear is a rapid/high performance/distributed/ORM framework based on .NET 2.0. V3 of NBear is a super big re-design based on the experience of V2, which reserves the IoC and Web module of V2 and bring a new ORM (in NBear.Common/NBear.Common.Design and NBear.Data). Old project site: http://sourceforge.net/projects/nbear/.

Latest Release

NBearLite V1.0.2.4 beta released: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=nbear&ReleaseId=9872.

NBear V3.7 stable released: http://www.codeplex.com/nbear/Release/ProjectReleases.aspx?ReleaseId=4141.

Official Project Site

http://nbear.org

Communities

Team Blog: http://nbteam.cnblogs.com/
Google Group: http://groups.google.com/group/nbeargroup
Official Forum (Chinese): http://nbear.cnblogs.com
MSN Group: nbeargroup@hotmail.com(Full), nbeargroup2@hotmail.com

Public SVN

http://svn.cnblogs.com:8080/svn/NBear

UPDATED RELEASE: NBearLite V1.0.2.4 (四月 14, 2008)

Mon, 14 Apr 2008 01:38:09 GMT

NBearLite Version 1.0.2.4 beta
-------------------------------

Author: Teddy (shijie.ma@gmail.com)

Official Site: http://nbear.org

Open Source License: BSD

Copyright: 2007-2010

Release Notes
-------------

Version 1.0.2.4 beta

1) Enhanced Not In, Not IS NULL operation of query expression.
2) OrderBy on Enahnced Expression.ALias() column.
3) Fix the "variable not declared" issue in complex query expression.
4) Add ExpressionClip.ToNumber() method, return column type is double or float.

Version 1.0.2.3 beta

1) Add DB2 Database Provider.
2) Add QueryColumns and StoredProcedure wrappers generating support for DB2 database.
3) Fix bug in NBearMapping when converting NULL Guid value.

Version 1.0.2.2 beta

1) Add ConstantCreateExpressionAttribute and ConstantUpdateExpressionAttribute class to support
constant create or update expression for specific fields.
e.g. If User class has a UpdateTime field, for either Create or Update, it's value should be updated
to the current database side getutcdate() value, you can Mark the field with the attributes like:
public class User : ActiveRecord<User>
{
...

[ConstantCreateExpressionAttribute(CommonConstantExpressions.GET_UTC_DATE)]
[ConstantUpdateExpressionAttribute(CommonConstantExpressions.GET_UTC_DATE)]
public DateTime UpdateTime;
}

2) Add ReadOnlyActiveRecord and ReadOnlyAssociationRecord class.
3) Add Left & Right Outer join support to Database.Select.

Version 1.0.2.1 beta

1) Change all T[] ToList<T>() methods to ToArray<T>() and add List<T> ToList<T>() methods.

2) Add simplified Initialize(Database db, IQueryTable table) methods to ActiveRecord and
AssociationRecord class.

3) Update the NBearLite PetShop 4.0 sample to use the latest NBearLite dlls,
package the NBearLite PetShop 4.0 sample into the binary distribution zip.

Version 1.0.2.0 beta

1) NBear.Mapping fixed the bug when converting data to Hierarchical classes.

2) NBear.Mapping fixed the bug when converting NULL value.

3) New NBearLite.ActiveRecord and AssociationRecord class implementing the ActiveRecord pattern.

4) New NBearLiteDataSource and DropDownListField web control and a NBearLite.WebTest website.

5) Updated documentation for new classes and controls.

Version 1.0.1.6 beta

1) Add ToScalar<ReturnType>() method to SelectSqlQuery, add ToScalar<ReturnType>(),
ToSubQuery(), ToSingleObject() and ToList() methods to CustomSqlQuery class.

2) Packaged the WebControls DLL of the open source Microsoft patterns & practices
Web Client Software Factory June 2007 into the dist folder.
You can download its source code from: http://www.codeplex.com/websf

Version 1.0.1.5 beta

1) Add Alias() and Select() for select on SubQuery support.
e.g.
DataSet ds = db.Select(Northwind.Categories,
(Northwind.Categories.CategoryID + 1).Alias("ID"),
(Northwind.Categories.CategoryName + "_teddy").Alias("Name"))
.SetSelectRange(10, 0, Northwind.Categories.CategoryID)
.ToSubQuery()
.Alias("Top10Cats")
.Select(new QueryColumn("ID", DbType.Int32),
new QueryColumn("Top10Cats.Name", DbType.String))
.Where(new QueryColumn("Top10Cats.ID", DbType.Int32) > 0 &&
new QueryColumn("Name", DbType.String).Trim().Length > 8)
.ToDataSet()

Version 1.0.1.4 beta

1) Fix bug in ExpressionClip.Trim() method.

Version 1.0.1.3 beta

1) Fix bug in Load AdditionalDbProviders Assembly in some environments.

Version 1.0.1.2 beta

1) Fix bug in Batch Insert.
2) Add ExpressionClip.Alias() method to support column alias.
3) Fix bug when using cloumn alias in MsAccess provider.
4) Fix bug in using AddtionalDbProviders in websites.
5) Add the NBearLite PetShop 4.0 Sample.

...

RELEASED: NBearLite V1.0.2.4 (Apr 14, 2008)

Mon, 14 Apr 2008 01:38:09 GMT

UPDATED WIKI: Home

teddycn — Wed, 16 Jan 2008 03:23:50 GMT

News Feeds

Introduction

NBearLite : NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. NBearLite is the new Core of the next generation of NBear V4 Framework, but can also be used seperately.

NBear is a rapid/high performance/distributed/ORM framework based on .NET 2.0. V3 of NBear is a super big re-design based on the experience of V2, which reserves the IoC and Web module of V2 and bring a new ORM (in NBear.Common/NBear.Common.Design and NBear.Data). Old project site: http://sourceforge.net/projects/nbear/.

Latest Release

NBearLite V1.0.1.5 beta (Integrated with NBear.Mapping, with NBearLite PetShop 4.0 example) released: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=nbear&ReleaseId=9872.

NBear V3.7 stable released: http://www.codeplex.com/nbear/Release/ProjectReleases.aspx?ReleaseId=4141.

Official Project Site

http://nbear.org

Communities

Team Blog: http://nbteam.cnblogs.com/
Google Group: http://groups.google.com/group/nbeargroup
Official Forum (Chinese): http://nbear.cnblogs.com
MSN Group: nbeargroup@hotmail.com(Full), nbeargroup2@hotmail.com

Public SVN

http://svn.cnblogs.com:8080/svn/NBear

RELEASED: NBearLite V1.0.1.5 (Integrated with NBear.Mapping) (Jan 16, 2008)

Wed, 16 Jan 2008 03:22:39 GMT

Release Notes
-------------

Version 1.0.1.5 beta

1) Add Alias() and Select() for select on SubQuery support.
e.g.
DataSet ds = db.Select(Northwind.Categories,
(Northwind.Categories.CategoryID + 1).Alias("ID"),
(Northwind.Categories.CategoryName + "_teddy").Alias("Name"))
.SetSelectRange(10, 0, Northwind.Categories.CategoryID)
.ToSubQuery()
.Alias("Top10Cats")
.Select(new QueryColumn("ID", DbType.Int32),
new QueryColumn("Top10Cats.Name", DbType.String))
.Where(new QueryColumn("Top10Cats.ID", DbType.Int32) > 0 &&
new QueryColumn("Name", DbType.String).Trim().Length > 8)
.ToDataSet()

Version 1.0.1.4 beta

1) Fix bug in ExpressionClip.Trim() method.

Version 1.0.1.3 beta

1) Fix bug in Load AdditionalDbProviders Assembly in some environments.

Version 1.0.1.2 beta

1) Fix bug in Batch Insert.
2) Add ExpressionClip.Alias() method to support column alias.
3) Fix bug when using cloumn alias in MsAccess provider.
4) Fix bug in using AddtionalDbProviders in websites.
5) Add the NBearLite PetShop 4.0 Sample.

Version 1.0.1.1 beta

1) Add ToSingleObject(viewName) and ToList(viewName) methods to SelectSqlSection class to
Support NBearMapping's mapping by viewName function.
2) Add ToDbCommandText() method to SelectSqlSection class to support generate SQL text from
strong typed query, you can use this function to generate SQL texts instead of write them manually.

Version 1.0.1.0 beta

1. Fix bug in "select distinct top" style query.
2. Fix bug in SQLServer2005 provider's "select range" style query.
3. Add "select output file encoding" support.
4. Integrate with NBear.Core and NBear.Mapping shared components.
5. Add ToSingleObject() and ToList() methods to SelectSqlSection class to support strong typed
query result.

Version 1.0.0.9 beta

1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool.
2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation
system's could not open it issue.

Version 1.0.0.8 beta

1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull.
2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with
a DbTransaction tran parameter.

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

{"dt.Rows[0]["}"CategoryName"]"} = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

{"dt.Rows[0]["}"CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
{"newRow["}"CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

UPDATED RELEASE: NBearLite V1.0.1.5 (Integrated with NBear.Mapping) (一月 16, 2008)

Wed, 16 Jan 2008 03:22:39 GMT

UPDATED WIKI: Home

teddycn — Tue, 15 Jan 2008 05:19:01 GMT

News Feeds

Introduction

NBearLite : NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. NBearLite is the new Core of the next generation of NBear V4 Framework, but can also be used seperately.

NBear is a rapid/high performance/distributed/ORM framework based on .NET 2.0. V3 of NBear is a super big re-design based on the experience of V2, which reserves the IoC and Web module of V2 and bring a new ORM (in NBear.Common/NBear.Common.Design and NBear.Data). Old project site: http://sourceforge.net/projects/nbear/.

Latest Release

NBearLite V1.0.1.4 beta (Integrated with NBear.Mapping, with NBearLite PetShop 4.0 example) released: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=nbear&ReleaseId=9872.

NBear V3.7 stable released: http://www.codeplex.com/nbear/Release/ProjectReleases.aspx?ReleaseId=4141.

Official Project Site

http://nbear.org

Communities

Team Blog: http://nbteam.cnblogs.com/
Google Group: http://groups.google.com/group/nbeargroup
Official Forum (Chinese): http://nbear.cnblogs.com
MSN Group: nbeargroup@hotmail.com(Full), nbeargroup2@hotmail.com

Public SVN

http://svn.cnblogs.com:8080/svn/NBear

UPDATED WIKI: Home

teddycn — Mon, 14 Jan 2008 02:37:25 GMT

News Feeds

Introduction

NBearLite : NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. NBearLite is the new Core of the next generation of NBear V4 Framework, but can also be used seperately.

NBear is a rapid/high performance/distributed/ORM framework based on .NET 2.0. V3 of NBear is a super big re-design based on the experience of V2, which reserves the IoC and Web module of V2 and bring a new ORM (in NBear.Common/NBear.Common.Design and NBear.Data). Old project site: http://sourceforge.net/projects/nbear/.

Latest Release

NBearLite V1.0.1.4 beta (Integrated with NBear.Mapping, with NBearLite PetShop 4.0 example) released: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=nbear&ReleaseId=9872.

NBear V3.7 stable released: http://www.codeplex.com/nbear/Release/ProjectReleases.aspx?ReleaseId=4141.

Official Project Site

http://nbear.org

Communities

Team Blog: http://nbteam.cnblogs.com/
Google Group: http://groups.google.com/group/nbeargroup
Official Forum (Chinese): http://nbear.cnblogs.com
MSN Group: nbeargroup@hotmail.com(Full), nbeargroup2@hotmail.com

Public SVN

http://svn.cnblogs.com:8080/svn/NBear/trunk

RELEASED: NBearLite V1.0.1.4 (Integrated with NBear.Mapping) (Jan 14, 2008)

Mon, 14 Jan 2008 02:35:32 GMT

Release Notes
-------------

Version 1.0.1.4 beta

1) Fix bug in ExpressionClip.Trim() method.

Version 1.0.1.3 beta

1) Fix bug in Load AdditionalDbProviders Assembly in some environments.

Version 1.0.1.2 beta

1) Fix bug in Batch Insert.
2) Add ExpressionClip.Alias() method to support column alias.
3) Fix bug when using cloumn alias in MsAccess provider.
4) Fix bug in using AddtionalDbProviders in websites.
5) Add the NBearLite PetShop 4.0 Sample.

Version 1.0.1.1 beta

1) Add ToSingleObject(viewName) and ToList(viewName) methods to SelectSqlSection class to
Support NBearMapping's mapping by viewName function.
2) Add ToDbCommandText() method to SelectSqlSection class to support generate SQL text from
strong typed query, you can use this function to generate SQL texts instead of write them manually.

Version 1.0.1.0 beta

1. Fix bug in "select distinct top" style query.
2. Fix bug in SQLServer2005 provider's "select range" style query.
3. Add "select output file encoding" support.
4. Integrate with NBear.Core and NBear.Mapping shared components.
5. Add ToSingleObject() and ToList() methods to SelectSqlSection class to support strong typed
query result.

Version 1.0.0.9 beta

1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool.
2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation
system's could not open it issue.

Version 1.0.0.8 beta

1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull.
2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with
a DbTransaction tran parameter.

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

{"dt.Rows[0]["}"CategoryName"]"} = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

{"dt.Rows[0]["}"CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
{"newRow["}"CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

Version 1.0.0.5 beta

1. Add ToDbCommand() method to SelectSqlSection class.

e.g. We can use database.Select(Northwind.Categories).ToDbCommand();

2. Enhance strong type query with sub query support. Add ToSubQuery()
method to SelectSqlSection class.

e.g. Sample strong type query with sub queries:

DataSet ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID.In
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID ==
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

Version 1.0.0.4 beta

1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure
Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases.

Version 1.0.0.3 beta

1. Fix bug in PostgreSql DbProvider.

Version 1.0.0.2 beta

1. Fix bug in preview version.
2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll.
3. Release as the first beta version.

Version 1.0.0.0 preview

1. Release the initial preview version.

UPDATED RELEASE: NBearLite V1.0.1.4 (Integrated with NBear.Mapping) (一月 14, 2008)

Mon, 14 Jan 2008 02:35:32 GMT

UPDATED WIKI: Home

teddycn — Mon, 14 Jan 2008 02:33:26 GMT

News Feeds

Introduction

NBearLite : NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. NBearLite is the new Core of the next generation of NBear V4 Framework, but can also be used seperately.

NBear is a rapid/high performance/distributed/ORM framework based on .NET 2.0. V3 of NBear is a super big re-design based on the experience of V2, which reserves the IoC and Web module of V2 and bring a new ORM (in NBear.Common/NBear.Common.Design and NBear.Data). Old project site: http://sourceforge.net/projects/nbear/.

Latest Release

NBearLite V1.0.1.4 beta (Integrated with NBear.Mapping, with NBearLite PetShop 4.0 example) released: https://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=nbear&ReleaseId=9872.

NBear V3.7 stable released: http://www.codeplex.com/nbear/Release/ProjectReleases.aspx?ReleaseId=4141.

Official Project Site

http://nbear.org

Communities

Team Blog: http://nbteam.cnblogs.com/
Google Group: http://groups.google.com/group/nbeargroup
Official Forum (Chinese): http://nbear.cnblogs.com
MSN Group: nbeargroup@hotmail.com(Full), nbeargroup2@hotmail.com

Public SVN

svn://svn.cnblogs.com:3690/NBear

UPDATED RELEASE: NBearLite V1.0.1.4 (Integrated with NBear.Mapping) (一月 14, 2008)

Mon, 14 Jan 2008 02:31:09 GMT

Release Notes
-------------

Version 1.0.1.4 beta

1) Fix bug in ExpressionClip.Trim() method.

Version 1.0.1.3 beta

1) Fix bug in Load AdditionalDbProviders Assembly in some environments.

Version 1.0.1.2 beta

1) Fix bug in Batch Insert.
2) Add ExpressionClip.Alias() method to support column alias.
3) Fix bug when using cloumn alias in MsAccess provider.
4) Fix bug in using AddtionalDbProviders in websites.
5) Add the NBearLite PetShop 4.0 Sample.

Version 1.0.1.1 beta

1) Add ToSingleObject(viewName) and ToList(viewName) methods to SelectSqlSection class to
Support NBearMapping's mapping by viewName function.
2) Add ToDbCommandText() method to SelectSqlSection class to support generate SQL text from
strong typed query, you can use this function to generate SQL texts instead of write them manually.

Version 1.0.1.0 beta

1. Fix bug in "select distinct top" style query.
2. Fix bug in SQLServer2005 provider's "select range" style query.
3. Add "select output file encoding" support.
4. Integrate with NBear.Core and NBear.Mapping shared components.
5. Add ToSingleObject() and ToList() methods to SelectSqlSection class to support strong typed
query result.

Version 1.0.0.9 beta

1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool.
2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation
system's could not open it issue.

Version 1.0.0.8 beta

1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull.
2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with
a DbTransaction tran parameter.

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

dt.Rows[0]["CategoryName"] = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

dt.Rows[0]["CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
newRow["CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

Version 1.0.0.5 beta

1. Add ToDbCommand() method to SelectSqlSection class.

e.g. We can use database.Select(Northwind.Categories).ToDbCommand();

2. Enhance strong type query with sub query support. Add ToSubQuery()
method to SelectSqlSection class.

e.g. Sample strong type query with sub queries:

DataSet ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID.In
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID ==
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

Version 1.0.0.4 beta

1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure
Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases.

Version 1.0.0.3 beta

1. Fix bug in PostgreSql DbProvider.

Version 1.0.0.2 beta

1. Fix bug in preview version.
2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll.
3. Release as the first beta version.

Version 1.0.0.0 preview

1. Release the initial preview version.

CREATED RELEASE: NBearLite V1.0.1.4 (Integrated with NBear.Mapping) (一月 14, 2008)

Mon, 14 Jan 2008 02:10:02 GMT

Release Notes
-------------

Version 1.0.1.4 beta

1) Fix bug in ExpressionClip.Trim() method.

Version 1.0.1.3 beta

1) Fix bug in Load AdditionalDbProviders Assembly in some environments.

Version 1.0.1.2 beta

1) Fix bug in Batch Insert.
2) Add ExpressionClip.Alias() method to support column alias.
3) Fix bug when using cloumn alias in MsAccess provider.
4) Fix bug in using AddtionalDbProviders in websites.
5) Add the NBearLite PetShop 4.0 Sample.

Version 1.0.1.1 beta

1) Add ToSingleObject(viewName) and ToList(viewName) methods to SelectSqlSection class to
Support NBearMapping's mapping by viewName function.
2) Add ToDbCommandText() method to SelectSqlSection class to support generate SQL text from
strong typed query, you can use this function to generate SQL texts instead of write them manually.

Version 1.0.1.0 beta

1. Fix bug in "select distinct top" style query.
2. Fix bug in SQLServer2005 provider's "select range" style query.
3. Add "select output file encoding" support.
4. Integrate with NBear.Core and NBear.Mapping shared components.
5. Add ToSingleObject() and ToList() methods to SelectSqlSection class to support strong typed
query result.

Version 1.0.0.9 beta

1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool.
2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation
system's could not open it issue.

Version 1.0.0.8 beta

1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull.
2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with
a DbTransaction tran parameter.

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

dt.Rows[0]["CategoryName"] = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

dt.Rows[0]["CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
newRow["CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

Version 1.0.0.5 beta

1. Add ToDbCommand() method to SelectSqlSection class.

e.g. We can use database.Select(Northwind.Categories).ToDbCommand();

2. Enhance strong type query with sub query support. Add ToSubQuery()
method to SelectSqlSection class.

e.g. Sample strong type query with sub queries:

DataSet ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID.In
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID ==
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

Version 1.0.0.4 beta

1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure
Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases.

Version 1.0.0.3 beta

1. Fix bug in PostgreSql DbProvider.

Version 1.0.0.2 beta

1. Fix bug in preview version.
2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll.
3. Release as the first beta version.

Version 1.0.0.0 preview

1. Release the initial preview version.

RELEASED: NBearLite V1.0.0.9 and NBearMapping v1.0.0.2 Beta (Aug 06, 2007)

Mon, 06 Aug 2007 01:23:29 GMT

NBearLite Version 1.0.0.9 beta
-------------------------------

Author: Teddy (shijie.ma@gmail.com)

Official Site: http://nbear.org

Open Source License: BSD

Copyright: 2007-2010

Release Notes
-------------

Version 1.0.0.9 beta

1. Fix bug of getting oracle table and view info in QueryColumnsGenerator.exe tool.
2. Change the NBearLite_Documentation format from chm to general HTML to prevent some operation
system's could not open it issue.

Version 1.0.0.8 beta

1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull.
2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with
a DbTransaction tran parameter.

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

dt.Rows[0]["CategoryName"] = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

dt.Rows[0]["CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
newRow["CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

Version 1.0.0.5 beta

1. Add ToDbCommand() method to SelectSqlSection class.

e.g. We can use database.Select(Northwind.Categories).ToDbCommand();

2. Enhance strong type query with sub query support. Add ToSubQuery()
method to SelectSqlSection class.

e.g. Sample strong type query with sub queries:

DataSet ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID.In
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID ==
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

Version 1.0.0.4 beta

1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure
Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases.

Version 1.0.0.3 beta

1. Fix bug in PostgreSql DbProvider.

Version 1.0.0.2 beta

1. Fix bug in preview version.
2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll.
3. Release as the first beta version.

UPDATED RELEASE: NBearLite V1.0.0.9 and NBearMapping v1.0.0.2 Beta (八月 06, 2007)

Mon, 06 Aug 2007 01:23:29 GMT

RELEASED: NBearLite V1.0.0.9 and NBearMapping v1.0.0.1 Beta (Aug 02, 2007)

Thu, 02 Aug 2007 02:22:06 GMT

UPDATED RELEASE: NBearLite V1.0.0.9 and NBearMapping v1.0.0.1 Beta (八月 02, 2007)

Thu, 02 Aug 2007 02:22:06 GMT

UPDATED RELEASE: NBearLite V1.0.0.8 and NBearMapping v1.0.0.1 Beta (七月 30, 2007)

Mon, 30 Jul 2007 08:46:21 GMT

NBearLite Version 1.0.0.8 beta
-------------------------------

Author: Teddy (shijie.ma@gmail.com)

Official Site: http://nbear.org

Open Source License: BSD

Copyright: 2007-2010

Release Notes
-------------

Version 1.0.0.8 beta

1. Fix type cast bug when QueryColumnsGenerator.exe generated out parameter value is dbnull.
2. Enhance QueryColumnsGenerator.exe to generate one more method for each stored procedure with
a DbTransaction tran parameter.

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

dt.Rows[0]["CategoryName"] = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

dt.Rows[0]["CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
newRow["CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

Version 1.0.0.5 beta

1. Add ToDbCommand() method to SelectSqlSection class.

e.g. We can use database.Select(Northwind.Categories).ToDbCommand();

2. Enhance strong type query with sub query support. Add ToSubQuery()
method to SelectSqlSection class.

e.g. Sample strong type query with sub queries:

DataSet ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID.In
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID ==
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

Version 1.0.0.4 beta

1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure
Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases.

Version 1.0.0.3 beta

1. Fix bug in PostgreSql DbProvider.

Version 1.0.0.2 beta

1. Fix bug in preview version.
2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll.
3. Release as the first beta version.

UPDATED RELEASE: NBearLite V1.0.0.7 and NBearMapping v1.0.0.1 Beta (七月 29, 2007)

Sun, 29 Jul 2007 07:12:01 GMT

NBearLite Version 1.0.0.7 beta
-------------------------------

Author: Teddy (shijie.ma@gmail.com)

Official Site: http://nbear.org

Open Source License: BSD

Copyright: 2007-2010

Release Notes
-------------

Version 1.0.0.7 beta

1. Fix bug in Aggregation select.
2. Provide Chinese version full documentation of NBearLite in doc folder.

Version 1.0.0.6 beta

1. Add ToDbCommand() method to InsertSqlSection/UpdateSqlSection/DeleteSqlSection classes.

2. Add 8 Save() method overridens to Database class to support DataTable/DataRows saving.
e.g. Sample Save code:
SelectSqlSection selectSection = db.Select(Northwind.Categories)
.Where(Northwind.Categories.CategoryID == catID)
.OrderBy(Northwind.Categories.CategoryID.Desc)
.SetSelectRange(1, 0, Northwind.Categories.CategoryID);
DataTable dt = selectSection.ToDataSet().Tables[0];

dt.Rows[0]["CategoryName"] = "modified";

//save a modified row
db.Save(selectSection.ToDbCommand(), 10, dt);

dt.Rows[0]["CategoryName"] = "modified2";

DataRow newRow = dt.NewRow();
newRow["CategoryName"] = "new";
dt.Rows.Add(newRow);

//save 1 modified row and insert a new row
db.Save(selectSection.ToDbCommand(), tran, 0, dt.Rows[0], dt.Rows[1]);

Version 1.0.0.5 beta

1. Add ToDbCommand() method to SelectSqlSection class.

e.g. We can use database.Select(Northwind.Categories).ToDbCommand();

2. Enhance strong type query with sub query support. Add ToSubQuery()
method to SelectSqlSection class.

e.g. Sample strong type query with sub queries:

DataSet ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID.In
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(10, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

ds = db.Select(Northwind.Products)
.Where(Northwind.Products.CategoryID ==
(
db.Select(Northwind.Categories, Northwind.Categories.CategoryID).SetSelectRange(1, 0, Northwind.Categories.CategoryID).ToSubQuery())
)
.ToDataSet();

Version 1.0.0.4 beta

1. Enhanced NBearLite.QueryColumnsGenerator to generate Stored Procedure
Wrapper methods for SqlServer, Oracle, MySql and PostgreSql databases.

Version 1.0.0.3 beta

1. Fix bug in PostgreSql DbProvider.

Version 1.0.0.2 beta

1. Fix bug in preview version.
2. Add PostgreSql DbProvider in NBearLite.AdditionalDbProviders.dll.
3. Release as the first beta version.

RELEASED: NBearLite V1.0.0.7 and NBearMapping v1.0.0.1 Beta (Jul 29, 2007)

Sun, 29 Jul 2007 07:12:01 GMT