static void Main(string[] args) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBV"].ConnectionString); try { connection.Open(); var results = connection.Query<DbvEntry>("select * from Dbv_Repository"); foreach (var r in results) { Console.Out.WriteLine("r.N = {0} {1} {2}", r.Name, r.Id, r.Data != null ? r.Data.Length : 0); } var cf = new ConnectionFactory(); var cft = new ConnectionTransactionFactory(); var rep = new DbvFinderRepository(cf, "DBV_REPOSITORY"); var e = rep.GetById(1); Console.Out.WriteLine("e.Name {0}, e.Id = {1}", e.Name, e.Id); var e1 = rep.GetById(1); Console.Out.WriteLine("e1.Name {0}, e1.Id = {1}", e1.Name, e1.Id); var wrep = new DbvWriterRepository(cf, "DBV_REPOSITORY"); e.Data = Encoding.UTF8.GetBytes("JUST A TEST"); e.UserName = "******"; e.CreatedTms = DateTime.Now; wrep.Update(e); var ne = new DbvEntry() { Name = "/test/test.csv", UserName = "******", CreatedTms = DateTime.Now, Description = "", Tags = "", Data = Encoding.UTF8.GetBytes("ANOTHER TAGS"), }; wrep.Add(ne); var sql = @"Select * from dbv_repository"; var cmd = connection.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = sql; cmd.Connection = connection; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { Console.Out.WriteLine("reader[0] = {0} {1} {2} {3} {4}", reader[0],reader[1],reader[2], reader[3],reader[4]); } } connection.Close(); } catch (Exception ex) { Console.Out.WriteLine("ex = {0}", ex); } if (System.Diagnostics.Debugger.IsAttached) Console.ReadKey(); }
static void Main(string[] args) { SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DBV"].ConnectionString); try { connection.Open(); var results = connection.Query <DbvEntry>("select * from Dbv_Repository"); foreach (var r in results) { Console.Out.WriteLine("r.N = {0} {1} {2}", r.Name, r.Id, r.Data != null ? r.Data.Length : 0); } var cf = new ConnectionFactory(); var cft = new ConnectionTransactionFactory(); var rep = new DbvFinderRepository(cf, "DBV_REPOSITORY"); var e = rep.GetById(1); Console.Out.WriteLine("e.Name {0}, e.Id = {1}", e.Name, e.Id); var e1 = rep.GetById(1); Console.Out.WriteLine("e1.Name {0}, e1.Id = {1}", e1.Name, e1.Id); var wrep = new DbvWriterRepository(cf, "DBV_REPOSITORY"); e.Data = Encoding.UTF8.GetBytes("JUST A TEST"); e.UserName = "******"; e.CreatedTms = DateTime.Now; wrep.Update(e); var ne = new DbvEntry() { Name = "/test/test.csv", UserName = "******", CreatedTms = DateTime.Now, Description = "", Tags = "", Data = Encoding.UTF8.GetBytes("ANOTHER TAGS"), }; wrep.Add(ne); var sql = @"Select * from dbv_repository"; var cmd = connection.CreateCommand(); cmd.CommandType = System.Data.CommandType.Text; cmd.CommandText = sql; cmd.Connection = connection; using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { Console.Out.WriteLine("reader[0] = {0} {1} {2} {3} {4}", reader[0], reader[1], reader[2], reader[3], reader[4]); } } connection.Close(); } catch (Exception ex) { Console.Out.WriteLine("ex = {0}", ex); } if (System.Diagnostics.Debugger.IsAttached) { Console.ReadKey(); } }