public QuestionAnswerService(string connectionString) { _factory = new OrmLiteConnectionFactory(connectionString, SqlServerDialect.Provider); _factory.Run(db => { db.CreateTable<QuestionAnswer>(overwrite: false); }); var svc = new AnswerService(connectionString); }
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); }