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); } }