Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Sql server real datatype, what is the C# equivalent?

Tags:

c#

sql-server

it is a Single

see here for more info on SQL Server to .Net DataTypes


Single is not the correct answer as it rounds the decimal part.. For instance 2.0799999 will be converted to 2.08. If there are no constraints regarding the rounding then it should be good.


Double can be used as the .NET Equivalent Datatype for Real Datatype of SQL Server

Double gets the exact value with out Rounding


The answer is Single. If you use double and your SQL field is type real it will error out. I tested this myself and confirmed.


in my project (acces -> firebird and ms sql -> c#) is real defined like single precission float point number...so I used float and everything is OK

Related questions

Difference between Parameters.Add(string, object) and Parameters.AddWithValue
Cannot resolve DbContext in ASP.NET Core 2.0
Get return value from stored procedure
Type-inferring a constant in C#
How can I programmatically check (parse) the validity of a TSQL statement?
C# to Java - Dictionaries?
Convert int to hex with leading zeros
Check if a string is a valid date using DateTime.TryParse
Difference between .Net Core, Portable, Standard, Compact, UWP, and PCL?
Most efficient way to test equality of lambda expressions
Nullable object must have a value?
Enable-Migrations Exception calling "SetData" with "2" argument(s)
How to append two stringBuilders?
asp.net asmx web service returning xml instead of json
Save time with parallel FOR loop
List<int> test = {1, 2, 3} - is it a feature or a bug?
Why is there no Linq method to return distinct values by a predicate?
How can I unit test my custom validation attribute
ReadOnlyException DataTable DataRow "Column X is read only."
Cascade deleting with EF Core

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!