public object Count() { DateTime startTime = DateTime.Now; const string viewName = "vw_allAds"; List<string> images = new List<string>(); var db = new Database(); var result = db.ExecuteScalar(string.Format("SELECT COUNT(id) FROM {0}", viewName)); db.Dispose(); return new { TimeStamp = (int)Math.Truncate((DateTime.UtcNow.Subtract(new DateTime(1970, 1, 1))).TotalSeconds), TimeConsumed = (DateTime.Now - startTime).TotalMilliseconds, Status = "Success", Result = new { Count = result } }; }