Παρουσίαση με Ετικέτες

• 2038
• ADO.net
• Column
• Data
• DateTime
• Extensions
• Future
• HowTo
• Int
• MySQL
• Overflow
• Posts
• SqlDataReader
• Timestamp
• Types

MySQL DATETIME vs TIMESTAMP and the year 2038
01 Νοεμβρίου 19 09:45 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Judging from MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/datetime.html, it sounds best to use DATETIME rather than TIMESTAMP if you want your database to be future proof. After all 2038 is only 18+ years away. The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' […]

Δημοσίευση στην κατηγορία: Posts, Data, Database, Types, SQL, DateTime, Future, Timestamp, Overflow, 2038, MySQL

How-to: get int value via ADO.net SqlDataReader using column name
21 Ιανουαρίου 19 08:54 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Based on Sam Holder’s answer at https://stackoverflow.com/questions/7388475/reading-int-values-from-sqldatareader/54296026, just contributed an extension method for fetching Int32 values via ADO.net’s SqlDataReader, without jumping through hoops (aka first fetch column ordinal [number] by name, then fetching the int value passing the column ordinal). Would be nice if Microsoft was providing such things out of the box. namespace adonet.extensions […]

Δημοσίευση στην κατηγορία: Posts, Extensions, HowTo, Database, SQL, ADO.net, Int, Column, SqlDataReader