Guest User

Untitled

a guest
Nov 23rd, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.24 KB | None | 0 0
  1. SELECT to_seconds(now()) - to_seconds(lastaccess) as seconds
  2. FROM survey WHERE id=@param
  3.  
  4. var i = _db.Database.FromSql<int>(
  5. @"SELECT to_seconds(now()) - to_seconds(lastaccess) as seconds
  6. FROM survey WHERE id=@param;",
  7. @param).ToList();
  8.  
  9. entity.Property(e =>e.LastAccessComputed)
  10. .HasComputedColumnSql("to_seconds(now()) - to_seconds(lastaccess)");
  11.  
  12. var conn = _context.Database.GetDbConnection();
  13. try
  14. {
  15. await conn.OpenAsync();
  16. using (var command = conn.CreateCommand())
  17. {
  18. string query = "SELECT EnrollmentDate, COUNT(*) AS StudentCount "
  19. + "FROM Person "
  20. + "WHERE Discriminator = 'Student' "
  21. + "GROUP BY EnrollmentDate";
  22. command.CommandText = query;
  23. DbDataReader reader = await command.ExecuteReaderAsync();
  24.  
  25. if (reader.HasRows)
  26. {
  27. while (await reader.ReadAsync())
  28. {
  29. var row = new EnrollmentDateGroup { EnrollmentDate = reader.GetDateTime(0), StudentCount = reader.GetInt32(1) };
  30. groups.Add(row);
  31. }
  32. }
  33. reader.Dispose();
  34. }
  35. }
  36. finally
  37. {
  38. conn.Close();
  39. }
Add Comment
Please, Sign In to add comment