MySql.Data.Entity.Tests.CanonicalFunctions.YearMonthDay C# (CSharp) Method

    public void YearMonthDay()
    {
      using (testEntities context = new testEntities())
      {
        ObjectQuery<DbDataRecord> q = context.CreateQuery<DbDataRecord>(
            @"SELECT c.DateBegan, Year(c.DateBegan), Month(c.DateBegan), Day(c.DateBegan)
                        FROM Companies AS c WHERE c.Id=1");
        foreach (DbDataRecord record in q)
        {
          Assert.AreEqual(1996, record[1]);
          Assert.AreEqual(11, record[2]);
          Assert.AreEqual(15, record[3]);
        }
      }
    }