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

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' […]
Δημοσίευση στην κατηγορία: , , , , , , , , , ,
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 […]
Δημοσίευση στην κατηγορία: , , , , , , , ,
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 […]
Δημοσίευση στην κατηγορία: , , , , , , ,

Search

Go

Ιστορικό Δημοσιεύσεων

Συνδρομές