What are the possible return values of TRUNCATE TABLE executed with Entity Framework's ExecuteSqlCommand?

Question

What is the return value of the following code when the code failed to execute ?

_Dbcontext.Database.ExecuteSqlCommand("TRUNCATE TABLE [TableName]");

I know that the value on succeed will be -1 but still don't know what other values expected to return if anything goes wrong . The official documentation from Microsoft said the return value of ExecuteSqlCommand is the result returned by the database after executing the command but what are the returned values of the command TRUNCATE?

what is the returned value in case of failed execution ? – Cyber Progs Jul 18 '17 at 14:40 — Cyber Progs, Jul 18 '17 at 14:40

score 4 · Accepted Answer · answered Jul 20 '17 at 09:48

I know that the value on succeed will be -1 but still don't know what other values expected to return if anything goes wrong.

TRUNCATE TABLE either (A) succeeds or (B) generates an error.

In .NET, this translates to (A) a return value of -1 or (B) an exception being thown. Since exceptions interrupt the control flow, there is no return value in the latter case.

What are the possible return values of TRUNCATE TABLE executed with Entity Framework's ExecuteSqlCommand?

1 Answers1