private static string Db(HttpListenerRequest request, HttpListenerResponse response) { var rnd = new Random(); var id = rnd.Next(10000); using (var conn = SqliteContext.GetConnection()) { conn.Open(); var result = conn.Query <RandomNumber>(@"SELECT * FROM World WHERE id=@id", new { id = id }).FirstOrDefault(); return(JSON.Serialize <RandomNumber>(result)); } }
private static void initDb() { var rnd = new Random(); using (var conn = SqliteContext.GetConnection()) { conn.Open(); using (var trans = conn.BeginTransaction()) { for (var i = 0; i < 10000; i++) { conn.Execute(@"INSERT INTO World (randomNumber) VALUES (@randomNumber)", new { randomNumber = rnd.Next(Int16.MaxValue) }, transaction: trans); } trans.Commit(); } } }
private static string Queries(HttpListenerRequest request, HttpListenerResponse response) { var count = GetQueries(request); var results = new List <RandomNumber>(); var rnd = new Random(); using (var conn = SqliteContext.GetConnection()) { conn.Open(); for (var i = 0; i < count; i++) { var id = rnd.Next(10000) + 1; var n = conn.Query <RandomNumber>(@"SELECT * FROM World WHERE id=@id", new { id = id }).FirstOrDefault(); results.Add(n); } } return(JSON.Serialize <List <RandomNumber> >(results)); }