public static void MainTest()
{
var connectionPool = new DbConnectionPool(new DbConnectionPoolPolicy(ConfigurationHelper.ConnectionString("TestDb")));
var repo = new Repository <TestEntity>(() => connectionPool.Get());
repo.Insert(new TestEntity
{
Token = "1233",
CreatedTime = DateTime.UtcNow
});
var entity = repo.Fetch(t => t.PKID == 1);
System.Console.WriteLine(entity.Token);
repo.Update(t => t.PKID == 1, t => t.Token, 1);
entity = repo.Fetch(t => t.PKID == 1);
System.Console.WriteLine(entity.Token);
repo.Delete(t => t.PKID == 1);
entity = repo.Fetch(t => t.PKID == 1);
System.Console.WriteLine($"delete operation {(entity == null ? "Success" : "Failed")}");
Console.WriteLine("finished.");
}
/// <summary>
/// Main Console Function
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
IContainer container = DependencyRegistrar.Init();
_productService = container.Resolve <IProductService>();
_cacheManager = container.Resolve <ICacheManager>();
_query = container.Resolve <IQuery>();
var list = _productService.GetAllProductList(ConfigurationHelper.ConnectionString(_cacheManager));
ScreenHelper.WriteItemsToConsole(list, ConfigurationHelper.GetMaterialIDsWhichCountWillNotBeDisplayed(_cacheManager));
}
public virtual void QueryTest()
{
var dbHelper = new DbHelper(ConfigurationHelper.ConnectionString(ConnStringKey), _dbType);
Assert.NotNull(dbHelper.DatabaseName);
var tables = dbHelper.GetTablesInfo();
Assert.NotNull(tables);
Assert.NotEmpty(tables);
foreach (var table in tables)
{
var columns = dbHelper.GetColumnsInfo(table.TableName);
Assert.NotNull(columns);
Assert.NotEmpty(columns);
}
}
public static void StorageProcusureTest()
{
using (var conn = new SqlConnection(ConfigurationHelper.ConnectionString("TestDb")))
{
//var result = conn.Execute("TestSP", CommandType.StoredProcedure, new { aaa = 123, bbb = "12333" });
//var dataTable = conn.ExecuteDataTable("SELECT * FROM TestTable");
try
{
conn.Execute(@"INSERT INTO [dbo].[TestTable]
(
[Token],
[CreatedTime]
)
VALUES
(@Item1, --Token - nvarchar(200)
@Item2-- CreatedTime - datetime
)", GetValueTupleParam());
}
catch (NotSupportedException ex)
{
Logger.Error(ex);
}
//conn.Execute(@"INSERT INTO [dbo].[TestTable]
// (
// [Token],
// [CreatedTime]
// )
// VALUES
// (@Token, --Token - nvarchar(200)
// @CreatedTime-- CreatedTime - datetime
// )", new TestStruct
//{
// Token = Guid.NewGuid().ToString("N")+" execute-struct",
// CreatedTime = DateTime.Now
//});
var i = conn.ExecuteDataTable("SELECT * FROM TestTable").Rows.Count;
}
}
public static void MainTest()
{
var connectionPool = new DbConnectionPool(new DbConnectionPoolPolicy(ConfigurationHelper.ConnectionString("Test")));
var repo = new Repository <TestEntity>(() => connectionPool.Get());
repo.Execute("TRUNCATE TABLE dbo.tabTestEntity");
repo.Insert(new TestEntity
{
Token = "1233",
CreatedTime = DateTime.UtcNow
});
var entity = repo.Fetch(t => t.Id == 1);
System.Console.WriteLine(entity.Token);
repo.Update(t => t.Id == 1, t => t.Token, 1);
entity = repo.Fetch(t => t.Id == 1);
System.Console.WriteLine(entity.Token);
var exists = repo.Exist(e => e.Id == 1);
Console.WriteLine($"exists pkid == 1: {exists}");
repo.Delete(t => t.Id == 1);
entity = repo.Fetch(t => t.Id == 1);
System.Console.WriteLine($"delete operation {(entity == null ? "Success" : "Failed")}");
exists = repo.Exist(e => e.Id > 1000);
Console.WriteLine($"exists PKID > 1000: {exists}");
repo.Execute("TRUNCATE TABLE dbo.tabTestEntity");
Console.WriteLine("finished.");
}
public static void MainTest()
{
var connString = ConfigurationHelper.ConnectionString("TestDb");
using (var conn = new SqlConnection(connString))
{
Init(conn);
for (int i = 0; i < 3; i++)
{
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
@CreatedTime-- CreatedTime - datetime
)", new TestEntity
{
Token = Guid.NewGuid().ToString("N") + "_Execute_Model",
CreatedTime = DateTime.Now
});
}
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
for (int i = 0; i < 3; i++)
{
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
GETDATE()-- CreatedTime - datetime
)", new TestEntity
{
Token = Guid.NewGuid().ToString("N") + "_Execute_Model_1"
});
}
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
for (int i = 0; i < 3; i++)
{
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
GETDATE()-- CreatedTime - datetime
)", new
{
Token = Guid.NewGuid().ToString("N") + "_Execute_Anonymous_Model"
});
}
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
var tokens = conn.QueryColumn <string>("SELECT Token FROM [dbo].[TestTable111]");
Console.WriteLine("tokens:{0}", string.Join(",", tokens));
var ids = conn.Select <int>("SELECT PKID FROM [dbo].[TestTable111]");
Console.WriteLine("ids:{0}", string.Join(",", ids));
var lastId = conn.Fetch <int>("SELECT TOP 1 PKID FROM [dbo].[TestTable111] ORDER BY PKID DESC");
Console.WriteLine("lastId:{0}", lastId);
conn.Execute("Delete from TestTable111 where PKID > @pkid", new { pkid = 888 });
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
Console.WriteLine(conn.Fetch <TestEntity>("select top 1 * from TestTable111")?.Token);
foreach (var entity in conn.Select <TestEntity>("select * from TestTable111"))
{
Console.WriteLine(entity.Token);
}
Clean(conn);
}
}
public BaseRepository()
{
//初始化数据库操作对象
DbHandle = new SqlServerHandle(ConfigurationHelper.ConnectionString("connStr"));
}
public static string ConnectionString() => ConfigurationHelper.ConnectionString();
public static void MainTest()
{
using (var conn = new SqlConnection(ConfigurationHelper.ConnectionString("TestDb")))
{
Init(conn);
var aaaa = conn.Fetch <TestEntity>("SELECT * FROM [dbo].[TestTable111]");
for (int i = 0; i < 3; i++)
{
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
@CreatedTime-- CreatedTime - datetime
)", new TestEntity
{
Token = Guid.NewGuid().ToString("N") + "_Execute_Model",
CreatedTime = DateTime.Now
});
}
var tokens = conn.QueryColumn <string>("SELECT Token FROM [dbo].[TestTable111]").ToArray();
Console.WriteLine("tokens:{0}", string.Join(",", tokens));
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
for (int i = 0; i < 3; i++)
{
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
GETDATE()-- CreatedTime - datetime
)", new TestEntity
{
Token = Guid.NewGuid().ToString("N") + "_Execute_Model_1"
}, new SqlParameter("@Token", Guid.NewGuid().ToString("N")));
}
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
for (int i = 0; i < 3; i++)
{
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
GETDATE()-- CreatedTime - datetime
)", new
{
Token = Guid.NewGuid().ToString("N") + "_Execute_Anonymous_Model"
});
}
conn.Execute(@"INSERT INTO [dbo].[TestTable111]
(
[Token],
[CreatedTime]
)
VALUES
(@Token, --Token - nvarchar(200)
GETDATE()-- CreatedTime - datetime
)", new Dictionary <string, object>
{
{ "@Token", Guid.NewGuid().ToString("N") + " executed-dictionary" }
});
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
conn.Execute("Delete from TestTable111 where PKID > @pkid", new { pkid = 888 });
Console.WriteLine("Current data count:{0}", conn.ExecuteScalarTo <int>("SELECT COUNT(1) FROM [dbo].[TestTable111]"));
Clean(conn);
}
}
