部署 MVC3 Web 应用程序

发布于 2024-12-21 17:03:16 字数 821 浏览 2 评论 0原文

大家好，我正在尝试将 ASP.NET MVC3 应用程序部署到我的网络服务器。这就是我所做的：

将所有项目上传到Web服务器
创建一个新的空数据库，运行SQL脚本来创建表和PK
修改web.config文件的connectionString属性以指向
添加的在线数据库customErrors mode="On" 到 web.config

以下是我收到的错误：

抱歉，处理您的请求时发生错误。

System.InvalidOperationException：转换为值类型“Int32” 失败，因为具体化值为 null。要么是结果类型的泛型参数或查询必须使用可为 null 的类型。

这是我请求的页面的代码：

public ActionResult Index()
{
    ViewBag.Message = "Last game is #" + this.getLastGameId();
    return View();
}

public int getLastGameId()
{
    using (HockeyStatsEntities context = new HockeyStatsEntities())
    {
        return context.Dim_Game.Select(g => g.Game_id).Max();
    }
}

我猜这是因为表是空的，所以当我对数据库的查询返回 null 时，就会生成错误。

原文

Good day all, I am trying to deploy my ASP.NET MVC3 app to my webserver. This is what I've done:

Uploaded all the project to the web server
Created a new empty DB, ran SQL scripts to create the tables and PKs
Modified the web.config file's connectionString attribute to point to the online DB
added customErrors mode="On" to web.config

Here is what error I get:

Sorry, an error occurred while processing your request.

System.InvalidOperationException: The cast to value type 'Int32'
failed because the materialized value is null. Either the result
type's generic parameter or the query must use a nullable type.

Here is my code for the page I am requesting:

public ActionResult Index()
{
    ViewBag.Message = "Last game is #" + this.getLastGameId();
    return View();
}

public int getLastGameId()
{
    using (HockeyStatsEntities context = new HockeyStatsEntities())
    {
        return context.Dim_Game.Select(g => g.Game_id).Max();
    }
}

I am guessing this is because the tables are empty so that when my query to the db is returning null, that generates the error.

分享到QQ

分享到微博