| private GetTimeZoneId ( SqlConnection conn ) : Guid | ||
| conn | SqlConnection | |
| return | Guid | |
private Guid GetTimeZoneId(SqlConnection conn)
{
StringBuilder sql = new StringBuilder();
sql.AppendLine("select ID");
sql.AppendLine("from dbo.TIMEZONEENTRY");
sql.AppendLine("where NAME = 'UTC';");
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.Text;
cmd.CommandTimeout = this.ProcessCommandTimeout;
cmd.CommandText = sql.ToString();
return (Guid)cmd.ExecuteScalar();
}
}