.NET Framework Types and Their Equivalents SQL Server Data

General

.NET Framework Types and Their  Equivalents   SQL Server Data


SQL Server Data Types and Their .NET Framework Equivalents



Data types of sql server in .net 

SQL Server data type          CLR data type (SQL Server)    CLR data type (.NET Framework)  
varbinary                     SqlBytes, SqlBinary           Byte[]  
binary                        SqlBytes, SqlBinary           Byte[]  
varbinary(1), binary(1)       SqlBytes, SqlBinary           byte, Byte[] 
image                         None                          None

varchar                       None                          None
char                          None                          None
nvarchar(1), nchar(1)         SqlChars, SqlString           Char, String, Char[]     
nvarchar                      SqlChars, SqlString           String, Char[] 
nchar                         SqlChars, SqlString           String, Char[] 
text                          None                          None
ntext                         None                          None

uniqueidentifier              SqlGuid                       Guid 
rowversion                    None                          Byte[]  
bit                           SqlBoolean                    Boolean 
tinyint                       SqlByte                       Byte 
smallint                      SqlInt16                      Int16  
int                           SqlInt32                      Int32  
bigint                        SqlInt64                      Int64 

smallmoney                    SqlMoney                      Decimal  
money                         SqlMoney                      Decimal  
numeric                       SqlDecimal                    Decimal  
decimal                       SqlDecimal                    Decimal  
real                          SqlSingle                     Single  
float                         SqlDouble                     Double  

smalldatetime                 SqlDateTime                   DateTime  
datetime                      SqlDateTime                   DateTime 

sql_variant                   None                          Object  
User-defined type(UDT)        None                          user-defined type     
table                         None                          None 
cursor                        None                          None
timestamp                     None                          None 
xml                           SqlXml                        None

Data type comparison .net and ms sql server

Datatypes conversion related information

.NET Framework Types and Their  Equivalents   SQL Server Data


SQL Server Data Types and Their .NET Framework Equivalents



Data types of sql server in .net 

SQL Server data type          CLR data type (SQL Server)    CLR data type (.NET Framework)  
varbinary                     SqlBytes, SqlBinary           Byte[]  
binary                        SqlBytes, SqlBinary           Byte[]  
varbinary(1), binary(1)       SqlBytes, SqlBinary           byte, Byte[] 
image                         None                          None

varchar                       None                          None
char                          None                          None
nvarchar(1), nchar(1)         SqlChars, SqlString           Char, String, Char[]     
nvarchar                      SqlChars, SqlString           String, Char[] 
nchar                         SqlChars, SqlString           String, Char[] 
text                          None                          None
ntext                         None                          None

uniqueidentifier              SqlGuid                       Guid 
rowversion                    None                          Byte[]  
bit                           SqlBoolean                    Boolean 
tinyint                       SqlByte                       Byte 
smallint                      SqlInt16                      Int16  
int                           SqlInt32                      Int32  
bigint                        SqlInt64                      Int64 

smallmoney                    SqlMoney                      Decimal  
money                         SqlMoney                      Decimal  
numeric                       SqlDecimal                    Decimal  
decimal                       SqlDecimal                    Decimal  
real                          SqlSingle                     Single  
float                         SqlDouble                     Double  

smalldatetime                 SqlDateTime                   DateTime  
datetime                      SqlDateTime                   DateTime 

sql_variant                   None                          Object  
User-defined type(UDT)        None                          user-defined type     
table                         None                          None 
cursor                        None                          None
timestamp                     None                          None 
xml                           SqlXml                        None

Data type comparison .net and ms sql server

Datatypes conversion related information

By 07-Jun-2018 Views 171

Upcoming Articles

You may also read following recent Post

The Top 15 Highest Paid Programming Languages in 2023
35 By Junaid A

why i choose HostGator as hosting provider
12 By Junaid A

What are the latest trends in international business within your industry
12 By Junaid A

What is OCR in Development
32 By Junaid A

How to fix MongoDb connection issue with nestjs
61 By Tahir

What is Kinemaster pro mod?
55 By Shahzad Anjum

which tool and technology are best to develop, cross platform mobile app development
42 By Junaid A

8 Best FREE Cloud Storage
41 By Shahzad Anjum

How to quickly resolve scratch disk full error in Photoshop?
47 By Shahzad Anjum

how to take business email backup from ms outlook
28 By Junaid A

65% OFF WEB HOSTING
40 By Shahzad Anjum

Standard Web Hosting
44 By Shahzad Anjum

65% off Standard Web Hosting
50 By Shahzad Anjum

PM laptop scheme 2023
41 By Shahzad Anjum

What is shortcut key of "view in browser" in visual studio 2022
45 By Junaid A

Some of the important topics to learn C# quckilly.
45 By Ahsan

what is poco in web development?
58 By Junaid A

cPanel Hosting with 24/7 Support
71 By Shahzad Anjum

Why use dedicated server hosting?
89 By Shahzad Anjum

Dedicated Server Hosting is really turning point
47 By Junaid A

why website support contract is important
67 By Junaid A

30-day SEO plan to help you get started with optimizing your website
48 By Junaid A

why i choose HostGator as hosting provider
84 By Junaid A

any google chrome extension to manage to do list suggested by google
80 By Junaid A

how i can make my laptop as server for deployment of the website
54 By Junaid A

which one is good font family that is recommended by google for website
76 By Junaid A

suggest me hosting company that is offering dedicated server in affordable price
82 By Junaid A

Manchester City F.C. - Football club
52 By Junaid A

create custom error page for exception handling in asp.net mvc
60 By Junaid A

find folder path in sub domain
72 By Junaid A

facts about Hazrat Fatima (RA)
80 By Junaid A

Amazing Mobile apps by Google LLC
67 By Junaid A

5-second search to find 100s of opportunities.
67 By Junaid A

How to calculate percentage using function in ms sql server
56 By Junaid A

free screen recording software
105 By Junaid A

how we can make strong ourselves
102 By Junaid A

do right things on right time | what are the right things
85 By Junaid A

$1,000 cpc keywords
79 By Junaid A

High CPC keywords for blog
93 By Junaid A

How to grow 1% every day
119 By Junaid A

who is good web developer
108 By Junaid A

Skills that pay you forever
65 By Junaid A

5 websites to help you find content ideas
68 By Junaid A

The setup for the installation of visual studio is not complete. Please run the Visual Studio installer again to correct the issue.
99 By Junaid A

Generic error occurred in GDI
87 By Shoaib Khan

Live cricket match PAK vs ENG Final T20 World Cup 2022
154 By Junaid A

How to check data is inserted deleted or updated in ms sql database
102 By Junaid A

𝐔𝐩𝐰𝐨𝐫𝐤 𝐔𝐧𝐯𝐞𝐢𝐥𝐬 𝐓𝐨𝐩 𝟏𝟎 𝐌𝐨𝐬𝐭 𝐈𝐧-𝐃𝐞𝐦𝐚𝐧𝐝 𝐒𝐤𝐢𝐥𝐥𝐬
119 By Shoaib Khan

3 Reasons You Need A Graphic Designer
106 By Shoaib Khan

08 Colour Tools for designer
79 By Shoaib Khan

Ptv sports live cricket match today
217 By Junaid A

How to boot HP laptop from USB Drive?
116 By Junaid A

𝐟𝐫𝐞𝐞 𝐰𝐞𝐛𝐬𝐢𝐭𝐞𝐬 𝐟𝐨𝐫 𝐈𝐥𝐥𝐮𝐬𝐭𝐫𝐚𝐭𝐢𝐨𝐧
94 By Junaid A

What are ASP.NET security controls?
242 By Shoaib Khan

How to redirect user from one website to another using java script
435 By Junaid A

How to check Database size using sql script
205 By Junaid A

Getting error "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine"
231 By Junaid A

Microsoft defender SmartScreen prevented an unrecognized app from starting error
191 By Junaid A

Key points for ms sql server as professional DB Developer
218 By Junaid A

content negotiation in api
145 By Junaid A

How I can learn Article Writing
132 By aj

how we can make Design responsive
112 By Ihsan Ullah

CRUD in Asp.net MVC
127 By Ihsan Ullah

How we can set value of View beg in asp.net mvc?
137 By Ahsan

How to set and get value from TempData in asp.net mvc?
127 By Ahsan

How to set and get value from TempData in asp.net mvc?
162 By Ahsan

How to set and get value in localstorage using JavaScript?
149 By Ahsan

How to get and set session in Asp.net mvc?
130 By Ahsan

WEBSITE TESTING CHECK LIST
154 By Junaid A

What is life?
129 By Shoaib Khan

paragraph
135 By Ihsan Ullah

life
104 By khubaib Ahmad

country state and city database in ms sql server 2019
198 By Nasir Kiyani

LinkedIn Freelancing services
391 By Junaid A

How to run sql script file from Command prompt
1389 By Junaid A

website support contracts key points
1334 By Junaid A

find error login in windows server
1438 By Junaid A

In Vitro Fertilization Centres in India | Aarogya Hospital | Elawoman
1408 By

How to track users connected to ptcl wifi
1551 By Junaid A

How to change passsword of Qubee Device
538 By Junaid A

how to add shop in facebook
633 By Junaid A

WEBSITE TESTING CHECK LIST
728 By Junaid A

How to check .pk domain expiry
688 By Junaid A

How to start PMP
675 By Junaid A

How to check website rendering in different locations
664 By Junaid A

what is Digital Marketing
785 By Junaid A

How To Find The Gmail / Google Account Creation Date
669 By Junaid A

How to find address by Postal Code
197 By

Configure compnay email on gmail
685 By Junaid A

what are DBA job title designation
190 By

what is robots.txt
664 By Junaid A

How to enable gzip compression in asp.net mvc
196 By

.NET Framework Types and Their Equivalents SQL Server Data
171 By

find unused CSS in web site with Chrome DevTools
704 By Junaid A

What is CURL?
714 By Junaid A

615 By shaheer

631 By shaheer

178 By

How Improve Execution time of Queries
644 By Rizwan Saqib

What is Classified in Terms of SEO?
751 By Tayyab Mukhtar

What is a Full-Stack Developer?
683 By Junaid A

Difference Between Temp Table and Table Variable
703 By Rizwan Saqib

version control systems mostly used in development
573 By Junaid A

methodologies mostly used
76 By

Libraries, frameworks, and tools those are used for development work
676 By Junaid A

what are the functions in .net
96 By

MVC LEARNIG
258 By

what is storage.ide in visual sutdio 2017
274 By

The data connection could not be established: ETIMEDOUT - Connection attempt timed out Error: Connec
262 By

how perform processing on string
266 By

how to get UserIPAddress in asp.net mvc
274 By

Set GMT instead of DateTime.Now in asp.net MVC?
250 By

How to Reseed Table in SQL Server?
249 By

Show only two digit after decimal point. How to convert double to 2 number after the dot.
202 By

custom message for ValidationMessage
254 By

ValidationMessage overlapping the message
271 By

Kendo Date Picker format using Culture in asp.net mvc
296 By

Steps to add Export to excel option in kendo grid mvc
258 By

How to Implement Date Range Picker in asp.net mvc
266 By

Kendo UI Validator overlapping issue
266 By

show hide kendo ComboBox
275 By

How to Integrate kendo ComboBox in asp.net mvc
262 By

Active A Class In Layout
290 By

IN this we will tell you about the basic things related to API's While Contructing them.
251 By

Issues opening Excel documents - File format and extension of 'orders.xls' don't match. The file cou
242 By

TF400889: The following path contains more than the allowed 259 characters:
311 By

kendoValidator check which input in not valid
236 By

The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine Solved
251 By

How to convert json string to object in C#?
264 By

how to add metags in asp.net mvc
300 By

'System.Web.HttpException' occurred in System.Web.dll but was not handled in user code
289 By

Version Compatibility in the .NET Framework
265 By

Multiple errors occurred during the operation, the first of which is displayed below. A full error l
243 By

kendoGrid first row set selected
241 By

Unhandled Exception in ASP.NET 4.0.30319.0
264 By

How to right align text in mvc kendo grid
907 By

How to post uploaded file and form data in MVC using jquery?
245 By

asp.net mvc routing tricks
254 By

Download Microsoft Edge Browser for windows 7
277 By

Remove Cache in ASP .NET MVC (4,5,6)
265 By

How to restore or back up a database in SQL server 2012.
267 By

What is routes in AngularJS?
282 By

Attackers might be trying to steal your information from (for example, passwords, messages, or cred
252 By

filter by multiple values list in asp.net mvc
250 By

Remove Cache in ASP .NET MVC (4,5,6)
275 By

Recovering a database that is in the restoring state
255 By

Invalid Cast Exception was unhandled by user code in Caching.
244 By

dropdown select value not going to FormCollection in mvc
2962 By

LINQ to Entities does not recognize the method 'System.String ToShortDateString()' method, and this
289 By

how to replace one div html to another div html dynamically using jquery in mvc
619 By

unable to load the specified metadata resource. entity framework
239 By

how to check the file size using jquery and reset if size exceeded
406 By

how to call a function in c#
302 By

what are the functions in .net
400 By

Get week start and week end range between two date
373 By

How to collapse/expand panel and preserve its states during sessions
2817 By

How to improve performance in asp.net mvc application
352 By

DataSourceRequest request error on kendo grid apply filtering
2728 By

Submit Post - Article - Ask a Question - Ask an Interview Question - Submit Useful Links

.NET Framework Types and Their Equivalents SQL Server Data

Share This with your friend by choosing any social account

You may also read following recent Post