public void FormatGet_NoParamter_SameSql()
{
var sqlProvider = new MsSqlProvider {
SetContext = { TableType = typeof(SysUser) }
};
sqlProvider.FormatGet <SysUser>();
Equal("SELECT TOP 1 [SYS_USERID] AS [SysUserid],[CREATE_DATETIME] AS [CreateDatetime],[EMAIL] AS [Email],[MOBILE] AS [Mobile],[PASSWORD] AS [Password],[REAL_NAME] AS [RealName],[USER_NAME] AS [UserName],[USER_STATUS] AS [UserStatus],[USER_TYPE] AS [UserType] FROM [SYS_USER]", sqlProvider.SqlString.Trim());
}
public void FormatGet_Selector_SameSql()
{
var sqlProvider = new MsSqlProvider {
SetContext = { TableType = typeof(SysUser) }
};
sqlProvider.SetContext.SelectExpression = (Expression <Func <SysUser, dynamic> >)(a => a.Email);
sqlProvider.FormatGet <SysUser>();
Equal("SELECT TOP 1 [EMAIL] FROM [SYS_USER]", sqlProvider.SqlString.Trim());
}
