System.Data.CommandType enum identfies the type of a System.Data.Common.DbCommand instance. The enum has three values: Text (which identifies an ordinary SQL statement
StoredProcedure
TableDirect CommandType must not be set to StoredProcedure! CommandType has nothing to do with System.Data.CommandType