What is equivalent data type for c# float in sql server

Question

I have Created class

public class UserAppearanceSettings
{
    [Key]
    public long Id { get; set; }
    public string UserName { get; set; }
    public string SkinName { get; set; }
    public string FontName { get; set; }
    public float FontSize { get; set; }

}

my sql table script

CREATE TABLE [dbo].[UserAppearanceSettings](
[Id] [bigint] IDENTITY(1,1) NOT NULL,
[UserName] [nvarchar](50) NULL,
[SkinName] [nvarchar](50) NULL,
[FontName] [nvarchar](50) NULL,
[FontSize] [float] NULL
) ON [PRIMARY]

and getting error

The 'FontSize' property on 'UserAppearanceSettings' could not be set to a 'System.Double' value. You must set this property to a non-null value of type 'System.Single'.

What datatype should I use in sqlserver for Float

The .Net framework `System.Single` is mapped in SQL Server to `Real`. [Reference](https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-data-type-mappings) — Zohar Peled, Nov 22 '17 at 07:45
In your case, you should also pay attention to the **non-null value** requirement. — Filburt, Nov 22 '17 at 07:46

score 0 · Answer 1 · answered Nov 22 '17 at 07:41

0

I believe it should be double. https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/sql-server-data-type-mappings

answered Nov 22 '17 at 07:41

Vladimir Sadov

41
2

2

Instead of answering such questions, it is better to flag or vote to close as a duplicate. – Patrick Hofman Nov 22 '17 at 07:41
Well, yes, you are right. I am kind of new here. – Vladimir Sadov Nov 22 '17 at 07:43
I understand. That is exactly the reason I am telling you, before you get downvoted a lot. – Patrick Hofman Nov 22 '17 at 07:45
@PatrickHofman I want to change sql datatype not C# – pramod maurya Nov 22 '17 at 07:57
Then use the appropriate data type. See the duplicate referenced above your question: https://stackoverflow.com/questions/425389/c-sharp-equivalent-of-sql-server-datatypes – Patrick Hofman Nov 22 '17 at 07:58

score -1 · Answer 2 · answered Nov 22 '17 at 08:03

Use fluent API to instruct entity framework to behave differently than it would behave by convention. Do this in your override of DbContext.OnModelCreating.

If you want to tell entity framework that every float in your DbSet classes should have SQL Data type Float(size, d) use ConventionPrimitivePropertyConfiguration

public override void OnModelCreating(DbModelBuilder modelBuilder)
{
    // Treat every float as SQL FloatType(53:
    modelBuilder.Properties<float>
        .Configure(floatType => floatType.HasColumnType("float(53)");

    base:OnModelCreating(modelBuilder);
}

If you only want some float properties to have the float type use HasColumnType

modelBuilder.Entity<UserAppearanceSettings>()
    .Property(setting => setting.FontSize)
    .HasColumnType("float(53)");

What is equivalent data type for c# float in sql server

2 Answers2