CSHTML/SQL SUM 一行

Question

我知道在 mysql 中它的 SUM(size)，但由于某种原因在 razor cshtml 中构建它不一样，我找不到任何地方谈论在 cshtml 中添加或减去 2 个数字。那么，用来累加行大小的正确函数是什么？

代码：

@{
    Page.Title = "Home @";
    var PageTitle = "Home";

    var db = Database.Open("PhotoGallery");
    var shows = db.Query(@"SELECT * FROM Shows").ToList();
    var seasons = db.Query(@"SELECT * FROM Seasons").ToList();
    var episodes = db.Query(@"SELECT * FROM Episodes").ToList();
    var comics = db.Query(@"SELECT * FROM Comics").ToList();
    var artists = db.Query(@"SELECT * FROM Artists").ToList();
    var albums = db.Query(@"SELECT * FROM Albums").ToList();
    var comicsize = db.Query(@"SELECT SUM(size) FROM Comics").ToList();   
    var totalsizeb = comicsize;
}

<h1>@PageTitle</h1>
<p align="center">
    @shows.Count TV Shows | @seasons.Count Seasons | @episodes.Count Episodes | @comics.Count Comics | @artists.Count Artists | @albums.Count Albums<br />
     Bytes |  MB |  GB |  TB
</p>

错误：

Exception Details: System.Data.SqlServerCe.SqlCeException: The specified argument value for the
function is not valid. [ Argument # = 1,Name of function(if known) = SUM ]

Answer 1

如果您只对每个表的 Count 感兴趣，那么您应该 SELECT COUNT(*) FROM Shows 等等，而不是仅仅从每个表中提取所有数据算一下。

@{
    Page.Title = "Home @";
    var PageTitle = "Home";

    var db = Database.Open("PhotoGallery");
    var shows = (int)db.QueryValue(@"SELECT Count(*) FROM Shows");
    var seasons = (int)db.QueryValue(@"SELECT Count(*) FROM Seasons");
    var episodes = (int)db.QueryValue(@"SELECT Count(*) FROM Episodes");
    var comics = (int)db.QueryValue(@"SELECT Count(*) FROM Comics");
    var artists = (int)db.QueryValue(@"SELECT Count(*) FROM Artists");
    var albums = (int)db.QueryValue(@"SELECT Count(*) FROM Albums");
    var comicsize = (int)db.QueryValue(@"SELECT SUM(size) FROM Comics");   
    var totalsizeb = comicsize;
}

<h1>@PageTitle</h1>
<p align="center">
    @shows TV Shows | @seasons Seasons | @episodes Episodes | @comics Comics | @artists Artists | @albums Albums<br />
      Bytes |  MB |  GB |  TB
</p>

SUM 仅适用于数字类型，例如 int、numeric、money 和 float > 确保该列是表中的这些类型之一。