score:1
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
score:1
Its Equivalent is Single. Single is A floating point number within the range of -3.40E +38 through 3.40E +38.
Here is the latest from MSDN describes all SqlDbType and C# Equivalents
Similar Question and Answer
- What is the equivalent SQL Server type for the C# long type?
- Sql server real datatype, what is the C# equivalent?
- What is the equivalent for LOCK_ESCALATION = TABLE in SQL Server 2005?
- What is the equivalent of 'CREATE TABLE ... LIKE ..." in SQL Server
- What is C# equivalent of geography sql server datatype in .net framework 4.0?
- What is the Equivalent syntax of mysql " LIMIT " clause in SQL Server
- What is the equivalent to SQL Server Transactions in DB2?
- What is the SQL Server equivalent of Oracle bind variables in dynamic SQL?
score:1
the answer is Single
or float
. (depending on style.)
this is like the difference between String
and string
[source: ReSharper code suggestion "use type keyword" when using Single
. it suggested using float
.
score:5
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.
score:7
Double can be used as the .NET Equivalent Datatype for Real Datatype of SQL Server
Double gets the exact value with out Rounding
score:10
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.
score:77
it is a Single
see here for more info on SQL Server to .Net DataTypes
More questions
- What is the SQL Server equivalent to Oracle's Virtual Private Database?
- VB.NET: What is the equivalent of the SQL Server bit datatype?
- What is the Sql Server equivalent for Oracle's DBMS_ASSERT?
- What is the SQL Server equivalent for Oracle's systimestamp?
- What is the equivalent of Oracle's LAST_DAY() function in SQL Server 2008?
- What is the SQL Server equivalent to a linked table in MS Access?
- What is the Datatype for 10:00 AM PST in SQL Server
- What is the alternative Enum datatype in Microsoft SQL Server 2008 Management Studio?
- What is the equivalent of the oracle query SET UNUSED (Column_name) in SQL server
- What is the Equivalent syntax of mysql “ LIMIT ” clause in SQL Server 2008
- What is the equivalent of dm_os_volume_stats in SQL Server 2008 R2 in SQL Server 2008?
- What is the equivalent of CUME_DIST() in SQL Server 2008?
- What is the equivalent for datatype LONG in SQL Server?
- What is the equivalent SQL Server data type for Access attachment?
- What is the SQL Server equivalent of the following Access statement
- What is the best way to auto-generate INSERT statements for a SQL Server table?
- What is the best way to paginate results in SQL Server
- What is the use of GO in SQL Server Management Studio & Transact SQL?
- What is the equivalent of 'describe table' in SQL Server?
- What is the command to truncate a SQL Server log file?
- SQL Server Installation - What is the Installation Media Folder?
- What is the Oracle equivalent of SQL Server's IsNull() function?
More questions with similar tag
- Get Start and End Date from Week Number SQL Server
- Get MAX and MIN in a row SQL
- Sql Server: Count records (including zero) per ten-minute intervals
- Querying Random 10 Percent for Each Record in SQL Server 2008
- Isn't it possible to authenticate into a DBMS through ODBC without having to specify the user credentials in the connection string?
- Converting to float: CAST vs CONVERT vs *1.0
- disable order by in sql query
- Error Returned from a Select/Inner Join Statement
- How to backup Amazon RDS MS SQL Server database instance and restore locally
- What is the T-SQL code to grant VIEW definitions excluding Stored Procedures?
- PHP PDO Connection to SQL Server with integrated security?
- SQL Nested Case Statements Within Stored Proc
- Login failed for user 'Domain\\MachineName$'
- How does one make NHibernate stop using nvarchar(4000) for insert parameter strings?
- Find name of employees hired on different joining date
- Getting DB Server DateTime in application
- T-SQL Finding Missing item from another database
- How to sum group totals in SQL?
- SQL what is faster left 2 or convert(varchar(2),'Chgffgjjx')
- NodeJS- Export from SQL Server according to Stream
- Performance Overhead on SQL Server Temp Tables
- sqlcmd access : password with special character
- What does the negative sign indicates in the computed checksum value?
- SQL Server read csv binary from table
- SQL Server - Combine two select queries
- Async behavior in C# IIS and SQL Server
- What is SQL Sever's default format for converting dates from strings
- ASP.NET Web Application Administration Security section: Unable to connect to SQL Server DB
- SqlCommand - Select ISNULL
- update sql server datetime field