How to TRUNCATE table with C#

Question

How I can truncate a table with c#.

I do this but it doesn't work.

cmd.CommandText = "TRUNCATE TABLE dalbara;";
cmd.ExecuteNonQuery();

Visual Studio give me this error:

Invalid SQL command, you only can do 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE'

I want to delete and restart all of my access table. With the DELETE command, the autoincrement values, doesn't reset.

Answer 1

MySqlConnection connection = new MySqlConnection(Server=localhost;Database=dbase;Uid=root;password=;)    
string query = "TRUNCATE TABLE " + yourTableName
MySqlCommand cmd = new MySqlCommand(query, connection);
cmd.ExecuteNonQuery();

Use this code to truncate table

Answer 2

If you're some sort of database context you can do this:

dbContext.ExecuteCommand("TRUNCATE TABLE <tableName>");