开发工具:
文件大小: 2mb
下载次数: 0
上传时间: 2009-03-11
详细说明： 做数据映射层 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 ge nerated 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. ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
