Click here to Skip to main content
15,896,111 members
Home / Discussions / C#
   

C#

 
GeneralRe: dates and databases Pin
Pete O'Hanlon16-Dec-09 11:16
mvePete O'Hanlon16-Dec-09 11:16 
GeneralRe: dates and databases Pin
Luc Pattyn16-Dec-09 11:26
sitebuilderLuc Pattyn16-Dec-09 11:26 
GeneralRe: dates and databases Pin
Pete O'Hanlon16-Dec-09 11:33
mvePete O'Hanlon16-Dec-09 11:33 
GeneralRe: dates and databases Pin
Luc Pattyn16-Dec-09 11:48
sitebuilderLuc Pattyn16-Dec-09 11:48 
AnswerRe: dates and databases Pin
PIEBALDconsult16-Dec-09 3:45
mvePIEBALDconsult16-Dec-09 3:45 
GeneralRe: dates and databases Pin
Luc Pattyn16-Dec-09 10:46
sitebuilderLuc Pattyn16-Dec-09 10:46 
GeneralRe: dates and databases Pin
PIEBALDconsult16-Dec-09 11:57
mvePIEBALDconsult16-Dec-09 11:57 
AnswerRe: dates and databases Pin
David Skelly16-Dec-09 22:39
David Skelly16-Dec-09 22:39 
One thing to bear in mind is whether this database will be used for anything else, e.g. accessed directly from reporting tools rather than through your application code. In this case, holding the dates as a double may cause problems for the person writing the reports.

Personally, I would consider making the data access layer pluggable, with a separate table gateway[^] for each RDBMS you are going to support. That way, if your database has good date type support you can use it, if not you can fall back on using doubles. Either way, the bulk of your code doesn't know and doesn't care. In fact, you might only need two gateways: one that supports date types and one that doesn't. Then you have a simple configuration switch to flick at deployment time to control how the application stores data.

(Actually, that link above isn't the most helpful in the world. Buy the book, it's very good.)
QuestionA network-related or instance-specific error occurred while establishing a connection to SQL Server Pin
Tridip Bhattacharjee16-Dec-09 2:00
professionalTridip Bhattacharjee16-Dec-09 2:00 
AnswerRe: A network-related or instance-specific error occurred while establishing a connection to SQL Server PinPopular
#realJSOP16-Dec-09 2:52
professional#realJSOP16-Dec-09 2:52 
QuestionHow can I deploy an application using VISIFIRE Pin
cutudi16-Dec-09 1:57
cutudi16-Dec-09 1:57 
AnswerRe: How can I deploy an application using VISIFIRE Pin
#realJSOP16-Dec-09 2:53
professional#realJSOP16-Dec-09 2:53 
GeneralRe: How can I deploy an application using VISIFIRE Pin
cutudi16-Dec-09 2:56
cutudi16-Dec-09 2:56 
GeneralRe: How can I deploy an application using VISIFIRE Pin
#realJSOP16-Dec-09 3:01
professional#realJSOP16-Dec-09 3:01 
AnswerCross post. Also posted in the WPF forum Pin
Pete O'Hanlon16-Dec-09 3:22
mvePete O'Hanlon16-Dec-09 3:22 
QuestionMerging Headers of datagridview in C#.Net Pin
Kavyashri16-Dec-09 0:58
Kavyashri16-Dec-09 0:58 
AnswerRe: Merging Headers of datagridview in C#.Net Pin
#realJSOP16-Dec-09 2:54
professional#realJSOP16-Dec-09 2:54 
AnswerRe: Merging Headers of datagridview in C#.Net Pin
Dave Kreskowiak16-Dec-09 5:03
mveDave Kreskowiak16-Dec-09 5:03 
QuestionSubscript Characters? Pin
o m n i16-Dec-09 0:57
o m n i16-Dec-09 0:57 
AnswerRe: Subscript Characters? Pin
#realJSOP16-Dec-09 2:55
professional#realJSOP16-Dec-09 2:55 
AnswerRe: Subscript Characters? [modified] Pin
BillWoodruff18-Dec-09 12:00
professionalBillWoodruff18-Dec-09 12:00 
QuestionHashtable with Structure or Class Object Pin
Bruce Coward16-Dec-09 0:37
Bruce Coward16-Dec-09 0:37 
AnswerRe: Hashtable with Structure or Class Object Pin
Richard MacCutchan16-Dec-09 0:50
mveRichard MacCutchan16-Dec-09 0:50 
GeneralRe: Hashtable with Structure or Class Object Pin
Bruce Coward16-Dec-09 1:06
Bruce Coward16-Dec-09 1:06 
GeneralRe: Hashtable with Structure or Class Object Pin
Richard MacCutchan16-Dec-09 1:20
mveRichard MacCutchan16-Dec-09 1:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.