Example #1
0
    /// <summary>
    /// Test CUBRIDSchemaProvider GetIndexes() method
    /// </summary>
    private static void Test_GetIndexes()
    {
      using (CUBRIDConnection conn = new CUBRIDConnection())
      {
        conn.ConnectionString = TestCases.connString;
        conn.Open();

        CUBRIDSchemaProvider schema = new CUBRIDSchemaProvider(conn);
        DataTable dt = schema.GetIndexes(new string[] { "game" });

        Debug.Assert(dt.Columns.Count == 9);
        Debug.Assert(dt.Rows.Count == 5);

        Debug.Assert(dt.Rows[3][2].ToString() == "pk_game_host_year_event_code_athlete_code"); //Index name
        Debug.Assert(dt.Rows[3][4].ToString() == "True"); //Is PK?
      }
    }