Exemple #1
0
        private static void Main(string[] args)
        {
            var connectionString = $@"Server=docker-host;Database=TestDb;User ID=sa;Password=yourStrong(!)Password";

            DapperInitializer.RegisterAnnotatedTypeMap(); // register typeMap for entities with [TableAttribute]

            using (var txManager = new TransactionManager())
            {
                using (var dbManager = (DatabaseManager)DatabaseManager.NewBuilder(new DbContextOptionsBuilder()
                                                                                   .UseSqlServer(connectionString)
                                                                                   .Options)
                                       .SetTransactionManager(txManager)
                                       .SetQueryBuilder(new SqlServerQueryBuilder())
                                       .Build())
                {
                    var userRepository = new UserRepository(dbManager);
                    using (var txSupport = txManager.Begin())
                    {
                        //userRepository.FindAll();
                        //userRepository.FindAll(Enumerables.List(new UserEntity()));
                        //userRepository.Get(new UserEntity());
                        //userRepository.Add(new UserEntity());
                        //userRepository.AddAll(Enumerables.List(new UserEntity()));
                        //userRepository.Update(new UserEntity());
                        //userRepository.UpdateAll(Enumerables.List(new UserEntity()));
                        //userRepository.Delete(new UserEntity());
                        //userRepository.DeleteAll(Enumerables.List(new UserEntity()));

                        Console.WriteLine(userRepository.CountAll());
                        txSupport.Complete();
                    }
                }
            }
        }