原有项目升级到NBear 3.7.0 beta build 2

下载地址： 发布 NBearV3.7 beta build 2 公开测试版

我写的项目中, 进行了以下更改..
1. 更新EntityDesignToEntityConfig.xml文件, 将EntityConfigPath注释掉, 并将EntityConfig.xml 删除, 然后在Web.config中去掉entityConfig

<?xml version="1.0" encoding="utf-8" ?>
<EntityDesignToEntityConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<!--<EntityConfigPath>..\website\EntityConfig.xml</EntityConfigPath>
-->

</EntityDesignToEntityConfiguration>

<?xml version="1.0"?>
<configuration>

    <!--<configSections>
        <section name="entityConfig" type="NBear.Common.EntityConfigurationSection, NBear.Common"/>
    </configSections>
    <entityConfig>
        <includes>
            <add key="Sample Entity Config" value="~/EntityConfig.xml"/>
        </includes>
    </entityConfig>-->

</configuration>

原因: release_note.txt
4) Release denpendency from EntityConfig.xml files.
EntityDesignToEntity.exe tool of this version embeds meta-data configurations of entities to the gerated entities code,
which means external EntityConfig.xml files are not MUST specify now.
But if you specify external EntityConfig.xml files in Web.config/App.config, configurations in external EntityConfig.xml files will
overwrite the embedded configurations.

2. 查询方式的改变
原来的方式:

public Comment[] GetComments(int contentID, int pageSize, int pageNo, OrderByClip orderBy)
        {
            WhereClip where = WhereClip.All;
            if(contentID >0)
            {
                where = Comment._.ContentID == contentID;
            }
            return gateway.GetPageSelector<Comment>(where, orderBy, pageSize).FindPage(pageNo);
        }

现在改成用Gateway.From()方式

 public Comment[] GetComments(int contentID, int pageSize, int pageNo, OrderByClip orderBy)
        {
            pageNo--;
            if(contentID >0)
            {
                return gateway.From<Comment>().Where(Comment._.ContentID == contentID).OrderBy(orderBy).ToArray<Comment>(pageSize, pageSize * pageNo);
            }
            return gateway.From<Comment>().OrderBy(orderBy).ToArray<Comment>(pageSize, pageSize * pageNo);
        }

From()方法非常类似SQL语法的行为....ToArray()中, 第一个参数为分页大小,等效与Top N, 第二个参数是忽略掉前N条记录...
当PrimaryKey是Int型, 并且是按PrimaryKey排序时, 分页采用PrimaryKey > MAX(PrimaryKey)方式(降序则为PrimaryKey < Min(PrimaryKey)), 用上面的GetComments()方法, 生成的SQL语句如下:

-- ics.GetComments(1, 10, 1);
Text    SELECT TOP 10 [Comment].[ID],[Comment].[ContentID],[Comment].[User_ID],[Comment].[UserName],[Comment].[UserPageUrl],[Comment].[Title],[Comment].[Body],[Comment].[IP],[Comment].[ModifiedDate] FROM [Comment] WHERE [Comment].[ContentID] = @p6xbcgsrdnkc0xk ORDER BY [Comment].[ID]    
Parameters:
@p6xbcgsrdnkc0xk[Int32] = 1

-- ics.GetComments(1, 10, 3);
Text    SELECT TOP 10 [Comment].[ID],[Comment].[ContentID],[Comment].[User_ID],[Comment].[UserName],[Comment].[UserPageUrl],[Comment].[Title],[Comment].[Body],[Comment].[IP],[Comment].[ModifiedDate] FROM [Comment] WHERE ([Comment].[ContentID] = @p0iaahrq8xlay8a) AND [Comment].[ID]>(SELECT MAX([__T].[ID]) FROM (SELECT TOP 20 [Comment].[ID] AS [ID] FROM [Comment] WHERE [Comment].[ContentID] = @peyno72o4ia1nq4 ORDER BY [Comment].[ID]) [__T]) ORDER BY [Comment].[ID]    
Parameters:
@peyno72o4ia1nq4[Int32] = 1
@p0iaahrq8xlay8a[Int32] = 1

3. FindArray()方法同样需要转换成From()方法, 转换很简单, 直接From().ToArray(EntityType)()就行了....