NBearLite V1.0.0.9 and NBearMapping v1.0.0.2 Beta

Rating: No reviews yet
Downloads: 1837
Released: Aug 6, 2007
Updated: Aug 6, 2007 by teddycn
Dev status: -not yet defined by owner-

Recommended Download

Source Code NBearLite_v1.0.0.9_beta_with_doc.zip
source code, 2848K, uploaded Aug 2, 2007 - 1194 downloads

Other Available Downloads

Source Code NBearMapping_v1.0.0.2_beta.zip
source code, 653K, uploaded Aug 6, 2007 - 643 downloads

Release Notes

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().Tables0;

dt.Rows0"CategoryName" = "modified";

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

dt.Rows0"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.Rows0, dt.Rows1);


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.

Reviews for this release

No reviews yet for this release.