The CommandType Enumeration Value 512 Is Not Supported – Complete Fix in ASP.NET / .NET Framework

When Developers working with ADO.NET and SQL Server in .NET Framework or ASP.NET applications may get this error: “The CommandType enumeration value 512 is not supported by the .NET Framework SqlClient Data Provider” in their programming life. This error occurs when executing database commands using ADO.NET with an incorrect CommandType. The concern of this, SQL Server provider does not support CommandType.TableDirect (value 512).

Reason behind this behavior: Supported only by OleDb providers.

Error Code

cmd.CommandType = CommandType.TableDirect;

How to fix this error

✔ Solution 1 – Use CommandType.Text

For normal SQL queries:

cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT * FROM Employees";

✔ Solution 2 – Use StoredProcedure

For stored procedures:

cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetEmployees";