TvDatabase.TvBusinessLayer.GetOnairNow C# (CSharp) Method

    public IList<Program> GetOnairNow()
    {
      SqlBuilder sb = new SqlBuilder(StatementType.Select, typeof (Program));
      IFormatProvider mmddFormat = new CultureInfo(String.Empty, false);
      sb.AddConstraint(String.Format("startTime <= '{0}' and endTime >= '{1}'",
                                     DateTime.Now.ToString(GetDateTimeString(), mmddFormat),
                                     DateTime.Now.ToString(GetDateTimeString(), mmddFormat)));
      SqlStatement stmt = sb.GetStatement(true);
      return ObjectFactory.GetCollection<Program>(stmt.Execute());
    }