我正在使用Micro ORM PetaPOCO,我想使用类似的查询,我遇到了异常,如果有人知道,请帮助我。
var context = new PetaPoco.Database(Connection.connectionstring);
SqlQuery = @"SELECT CmsPage.PageId, CmsPage.PageTitle, CmsPage.MenuId, CmsPage.PageDescription, CmsPage.Title, CmsPage.MetaKeyword, CmsPage.MetaDescription, CmsPage.CreatedDate, CmsPage.IsActive
FROM ( SELECT ROW_NUMBER() OVER (ORDER BY CmsPage.PageTitle) AS row, CmsPage.PageId, CmsPage.PageTitle, CmsPage.MenuId, CmsPage.PageDescription,
CmsPage.Title, CmsPage.MetaKeyword, CmsPage.MetaDescription, CmsPage.CreatedDate, CmsPage.IsActive FROM CmsPage ) AS CmsPage WHERE
CmsPage.PageTitle LIKE @0 and row > ((@CurrPage - 1) * @PageSize) and row <= (@CurrPage * @PageSize)";
List<CmsPagePOCO> obCmsPagePOco = context.Query<CmsPagePOCO>(
SqlQuery,
new
{
@CurrPage = CurrPage,
@PageSize = PageSize,
@PageTitle = "%" + PageTitle + "%"
}).ToList();
return obCmsPagePOco;
正在获取此异常:
不存在来自对象类型<>f_AnonymousType1`3[[System.Int32,mscorlib,Version=4.0.0.0,Culture=neutral,PublicKeyToken=b77a5c561934e089],[System.Int32,mscollib,Version=4.0.0.0,Culture=neutral、PublicKeyToken=b77A5c561934e 089],[System.String,mscorllib,Version=40.0.0,Culture=neutrale,PublicKeyToken=b 77a5C561934e89]]转换为已知的托管提供程序本机类型。