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());
}
public void FormatCount_WhereForEmail_SameSql()
{
var sqlProvider = new MsSqlProvider {
SetContext = { TableType = typeof(SysUser) }
};
sqlProvider.SetContext.WhereExpression =
(Expression <Func <SysUser, bool> >)(a => a.Email == "*****@*****.**");
sqlProvider.SetContext.NoLock = true;
sqlProvider.FormatCount();
Equal("SELECT COUNT(1) FROM [SYS_USER] (NOLOCK) WHERE ([EMAIL] = @Email)", sqlProvider.SqlString.Trim());
}
static void Main(string[] args)
{
var settings = ReadAllSettings();
TxtProvider txtProvider = new TxtProvider(settings);
MsSqlProvider msSqlProvider = new MsSqlProvider();
var listData = txtProvider.CollectionDataLotto();
try
{
msSqlProvider.InsertDataFromCollection(listData, settings, settings);
Console.WriteLine("\nDownload data - Duzy Lotek - success\n");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
Console.ReadKey();
}
private Provider GetProvider(DbConnectionTypes connectionType, string connectionString)
{
Provider provider;
switch (connectionType)
{
case DbConnectionTypes.MsSql:
provider = new MsSqlProvider(connectionString);
break;
case DbConnectionTypes.Postgres:
provider = new PostgresProvider(connectionString);
break;
case DbConnectionTypes.Oracle:
provider = new OracleProvider(connectionString);
break;
default:
return(null);
}
return(provider);
}
