Skip to main content

Mapping .NET Data Types to MySQL Data Types

Mapping .NET Data Types to MySQL Data Types

.NET Data Types
MySQL Data Types
System.Boolean boolean, bit(1)
System.Byte tinyint unsigned
System.Byte[] binary, varbinary, blob, longblob
System.DateTime datetime
System.Decimal decimal
System.Double double
System.Guid char(36)
System.Int16 smallint
System.Int32 int
System.Int64 bigint
System.SByte tinyint
System.Single float
System.String char, varchar, text, longtext
System.TimeSpan time

DateTimeOffset type is not supported.

Comments

Post a Comment

Popular posts from this blog

How to post a dynamic form using json data?

// Post dynamic form using json data   function post(uri, data, method) { // when method not provided use default post method method = method || "post" ;     var form = document.createElement( "form" ); form.setAttribute( "method" , method); form.setAttribute( "action" , uri); for ( var property in data) {   if (params.hasOwnProperty(property)) {     var hiddenField = document.createElement( "input" );     hiddenField.setAttribute( "type" , "hidden" );     hiddenField.setAttribute( "name" , property);     hiddenField.setAttribute( "value" , data[property]);      form.appendChild(hiddenField);   } } document.body.appendChild(form); form.submit(); }
Post a Comment
Read more

C# - How to get Property Name and Value of a dynamic object?

C# - Dynamic Object Use the following code to get Name and Value of a dynamic object's property. dynamic d = new { Property1= "Value1", Property2= "Value2"}; var properties = d.GetType().GetProperties(); foreach (var property in properties) {     var PropertyName= property.Name; //You get "Property1" as a result     var PropetyValue= d.GetType().GetProperty(property.Name).GetValue(d, null); //You get "Value1" as a result // you can use the PropertyName and Value here  }
2 comments
Read more