版本更新

Top  Previous  Next

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.