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

• .NET
• 2038
• ADO.net
• Column
• Data
• Database
• DateTime
• Extensions
• Future
• HowTo
• Int
• Logging
• MySQL
• Overflow
• Parameters
• Posts
• SqlCommand
• SqlDataReader
• Timestamp
• Types
• Workarround

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

Getting resulting SQL string from parametric ADO.net SqlCommand
19 Σεπτεμβρίου 18 07:18 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Microsoft is suggesting to always use Named parameters with SqlCommands for security reasons (to avoid SQL injection exploits), but they haven’t thought of providing a property at SqlCommand to give you back the result SQL so that you can have your app log it without resorting to SQL Server for that logging. Found a solution […]

Δημοσίευση στην κατηγορία: .NET, Posts, Workarround, SqlCommand, SQL, Logging, ADO.net, Parameters