NBearLite .net 开发框架

NBearLite Version 1.0.1.5 beta ------------------------------- Author: Teddy (shijie.ma@gmail.com) Official Site: http://nbear.org Open Source License: BSD Copyright: 2007-2010 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]); 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. Introdution Q & A ----------------- Q: What is NBearLite? A: NBearLite is a .NET 2.0 data access component which supports MsAccess, SqlServer, Oracle, Sqlite, MySql, PostgreSql databases. Q: Is NBearLite an O/R Mapping component? A: No. Q: Then what are the main features of NBearLite? A: With NBearLite, you can transparently query databases by a strong type query language similar to LINQ. The strong type query language provided by NBearLite supports not only basic CRUD but also complex select queries with ORDER BY, GROUP BY, PAGING, INNER JOIN, BATCH OPERATION...- Most common database operations we may met in our development life, which significantly simplifies database operations from our .Net code and saves our development time. The select query of NBearLite returns Scalar, DataSet or IDataReader. Q: Is NBearLite easy to use? A: Yes, super easy. You can easily reference NBearLite.dll, use NBearLite.QueryColumnsGenerator.exe tool provided by together with NBearLite.dll to generate QueryColumns code from existing database and then freely query your database through NBearLite's strong type query language. Please check code in NBearLite.Test project for basic usage. NBearLite.QueryColumnsGenerator itself is a sample WinForm application using NBearLite. More tutorials is incoming. Q: What is the relation of NBearLite and NBear? A: NBearLite is maintained by NBear team. It shares the DbProvider and query kernalcode of NBear but provides cleaner namespaces, code structure and more powerful data access fucntions working with ADO.NET build-in DataSet instead of Entity classes in NBear. Yes, to begin from NBearLite, there is no need to write any entity classes or entity configurations.