public static void DimDateInitializer(int startDate) { //010115 DateTime date = DateTimeHelper.ConvertToDateTime(startDate); List<DateTime> datesToInsert = new List<DateTime>(); while (date.Year <= DateTime.Now.Year) { Console.WriteLine(date.ToString()); datesToInsert.Add(date); date = date.AddDays(1); } //220101 //22 01 2001 DBController dbc = new DBController(); foreach (DateTime dateToInsert in datesToInsert) { dbc.AddDimDate(dateToInsert); } dbc.Close(); }