sql - 为什么我的 Entity Framework 将 '2.87' 变成了 '2'(十进制字段)？

Question

我验证了正确的值 '2.87' 正在进入服务......并且根据 EF 图表，'Score' 字段的类型是'Decimal'......但在数据库中它只是说'2'

   [OperationContract]
        public void AddHighScore(string strName, decimal dScore, int iLevel)
        {
            using (SQL2008R2_789485_punkouterEntities1 dc = new SQL2008R2_789485_punkouterEntities1())
            {
                HighScore oHighScore = new HighScore();
                oHighScore.Level = iLevel;
                oHighScore.Name = strName;
                //oHighScore.Name = dScore.ToString();
                oHighScore.Score = dScore;
                dc.AddToHighScores(oHighScore);
                dc.SaveChanges();
            }
        }


-- --------------------------------------------------
-- Creating all tables
-- --------------------------------------------------

-- Creating table 'HighScores'
CREATE TABLE [dbo].[HighScores] (
    [Id] int IDENTITY(1,1) NOT NULL,
    [Name] nvarchar(max)  NOT NULL,
    [Score] decimal(18,0)  NOT NULL,
    [Level] int  NOT NULL
);
GO

Answer 1

您需要在小数字段上设置比例。将分数字段更改为十进制(18,2)

See Decimal help File on MSDN

您可以通过首先选择该字段在 EF 中设置比例，然后在属性窗口中您将看到比例的属性(见图)