public QuestionAnswerService(string connectionString)
        {
            _factory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
            _factory.Run(db =>
            {
                db.CreateTable<QuestionAnswer>(overwrite: false);
            });

            var svc = new AnswerService(connectionString);
        }
Example #2
0
        public QuestionService(string connectionString)
        {
            _factory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider);
            _factory.Run(db =>
            {
                db.CreateTable<Question>(overwrite: false);

                if (db.Count<Question>() == 0)
                {
                    db.Insert<Question>(new Question { Id = 1, Order = 1, SegmentId = 1, Text = "What is your favorite color?" });
                    db.Insert<Question>(new Question { Id = 2, Order = 2, SegmentId = 1, Text = "What is your quest?" });

                    db.Insert<Question>(new Question { Id = 3, Order = 1, SegmentId = 2, Text = "One more question?" });
                }
            });

            var svc = new AnswerService(connectionString);
        }