Passing sql row/column to method

Question

I have some classes that model my tables. Many of the tables have a sql server DateTime, which is a c# DateTime in my classes. The code looks something like "FIGURE 1" below. As I do this often I want to put in a static method that I can call my each of my classes. My problem is that I dont know how to represent the parameter (a specific sqldatreader column/row) in the static method, "FIGURE 2" below.

FIGURE 2

public static DateTime SqlDateTimeSet(????)
{
    DateTime dt;
    if (?????) // // true = null in test
        dt = DateTime.MinValue;
    else
        dt = ????;
    return dt;  
}

FIGURE 1

User usr = new User();
int ordinal = <nullable DateTime column>;
if (dr.IsDBNull(ordinal))
    usr.DisableDate = DateTime.MinValue;
else
    usr.DisableDate = dr.GetDateTime(ordinal);

Steve Danner · Accepted Answer · 2011-04-26 18:09:50Z

1

You should be able to convert a SQL Date/Time to a .NET DateTime like this (where the passed in value is something from a DataReader like myDataReader["myDateTime"]:

public static DateTime SqlDateTimeSet(object drValue)
{
    DateTime? dt;
    dt = drValue as DateTime?;
    return dt.GetValueOrDefault();
}

answered Apr 26, 2011 at 18:09

Steve Danner

22.2k7 gold badges45 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Leons · Accepted Answer · 2011-04-26 18:10:05Z

0

Here is an example of a general extension method that will work.

  public static class DataRowExtensions
  {
    public static T FieldOrDefault<T>(this DataRow row, string columnName)
    {
      return row.IsNull(columnName) ? default(T) : row.Field<T>(columnName);
    }
  }

answered Apr 26, 2011 at 18:10

Leons

2,6741 gold badge23 silver badges26 bronze badges

Collectives™ on Stack Overflow

Passing sql row/column to method

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related