原有项目升级到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"?>
<configuration>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
<!--<configSections>
<section name="entityConfig" type="NBear.Common.EntityConfigurationSection, NBear.Common"/>
</configSections>
<entityConfig>
<includes>
<add key="Sample Entity Config" value="~/EntityConfig.xml"/>
</includes>
</entityConfig>-->
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
</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()方式
From()方法非常类似SQL语法的行为....ToArray()中, 第一个参数为分页大小,等效与Top N, 第二个参数是忽略掉前N条记录...
当PrimaryKey是Int型, 并且是按PrimaryKey排序时, 分页采用PrimaryKey > MAX(PrimaryKey)方式(降序则为PrimaryKey < Min(PrimaryKey)), 用上面的GetComments()方法, 生成的SQL语句如下:
3. FindArray()方法同样需要转换成From()方法, 转换很简单, 直接From().ToArray(EntityType)()就行了....
我写的项目中, 进行了以下更改..
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">
![](https://www.cnblogs.com/Images/dot.gif)
<!--<EntityConfigPath>..\website\EntityConfig.xml</EntityConfigPath>
-->
![](https://www.cnblogs.com/Images/dot.gif)
</EntityDesignToEntityConfiguration>
<EntityDesignToEntityConfiguration xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
![](https://www.cnblogs.com/Images/dot.gif)
<!--<EntityConfigPath>..\website\EntityConfig.xml</EntityConfigPath>
-->
![](https://www.cnblogs.com/Images/dot.gif)
</EntityDesignToEntityConfiguration>
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/dot.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
原因: 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. 查询方式的改变
原来的方式:
![](https://www.cnblogs.com/Images/OutliningIndicators/None.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/InBlock.gif)
![](https://www.cnblogs.com/Images/OutliningIndicators/ExpandedBlockEnd.gif)
现在改成用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);
}
{
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
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)()就行了....