SQL Server Float and Real datatypes

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

What are the best .NET datatypes to handle SQL Server's Float and Real
datatypes? I'd like to avoid using the SQL Server specific datatypes like
SqlInt32 or similar.

Thanks in advance.

-Mark
 
And if I still didn't want to use the SqlXxxxx datatypes, which .NET
datatypes would work best? Thanks again.

Mark
 
Okay I should have been a bit clearer. Here is the conversion you need --

Native Sql Server Float --> System.Data.SqlTypes.SqlDouble --> .NET DataType
Double
Native Sql Server Real --> System.Data.SqlTypes.SqlSingle --> .NET
DataType Single

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

C# to SQL Server datatype mappings 2
Handlling different Data types 8
Extracting Image datatype content with SQL2005? 23
Which data type should I use for a money value? 5
C#.Net get SQL image datatype 2
Database datatype to c# datatype 3
appropriate C# types for SqlDbType.Money and SqlDbType.DateTime? 2
Getting SQL data types using C# 5

Back
Top