c# - SQL LINQ 转换为字符串

Question

如何将 dateTime SQL 转换为可以格式化的字符串？我还没有找到将“requestIniationDate”转换为可以格式化的字符串的方法。

protected void Page_Load(object sender, EventArgs e)
{
    //"data" is a database connection through the Data folder, containing the tables
    var data = new Data.AcademicCodeRequestDBEntities();

    var request = data.Requests.Select(x => new 
                        {
                            x.appName, 
                            x.requestIniatiationDate, 
                            x.status, 
                            x.id
                        }).ToList()
                        .Select(x => new Models.RequestIdentifier() 
                        {
                            id = x.id,
                            appName = x.appName,
                            requestIniatiationDate = x.requestIniatiationDate,
                            status = x.status,

                        });
    editGrid.DataSource = request;
    editGrid.DataBind();
}

标签： c#linqtostring

Answer 1

怎么用.ToString("d")？请参阅 https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-date-and-time-format-strings

protected void Page_Load(object sender, EventArgs e) {
    var data = new Data.AcademicCodeRequestDBEntities();
    var request = data.Requests.Select(x => new 
                    {
                        x.appName, 
                        x.requestIniatiationDate.ToString("d"), 
                        x.status, 
                        x.id
                    }).ToList()
                    .Select(x => new Models.RequestIdentifier() 
                    {
                        id = x.id,
                        appName = x.appName,
                        requestIniatiationDate = x.requestIniatiationDate.ToString("d"),
                        status = x.status,
                    });
    editGrid.DataSource = request;
    editGrid.DataBind();
}