private static string Fortunes(HttpListenerRequest request, HttpListenerResponse response) { List <Fortune> fortunes; using (var conn = SqliteContext.GetConnection()) { conn.Open(); fortunes = conn.Query <Fortune>(@"SELECT * FROM Fortune").ToList(); } fortunes.Add(new Fortune { ID = 0, Message = "Additional fortune added at request time." }); fortunes.Sort(); response.ContentType = "text/html"; const string header = "<!DOCTYPE html><html><head><title>Fortunes</title></head><body><table><tr><th>id</th><th>message</th></tr>"; const string footer = "</table></body></html>"; var body = string.Join("", fortunes.Select(x => "<tr><td>" + x.ID + "</td><td>" + x.Message + "</td></tr>")); return(header + body + footer); }
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)); }