How to truncate table using Telerik OpenAccess ORM?

Question

I've tried to

ObjectScope.GetSqlQuery("TRUNCATE TABLE %table_name%", null, null).Execute();

and

ObjectScope.GetOqlQuery("TRUNCATE TABLE %ClassName%Extent").Execute();

The first row does nothing. And the second throw Exception:

line 1:10: unexpected token: ["TABLE",<42>,line=1,col=10]
Original Query: TRUNCATE TABLE DayExtent

Of course, In real code I provide table name. I've used %table_name% as a placeholder. — Enlightened, Aug 08 '11 at 12:06

score 1 · Answer 1 · answered Aug 30 '11 at 09:29

The method ExecuteDDLScript doesn't make a difference between DDL and DML script. It only requires that there are no open object scopes.

        IObjectScope scope = ObjectScopeProvider1.GetNewObjectScope();
        //do something here
        scope.Dispose();
        string tableToTruncate = "SOME_TABLE";
        scope.Database.GetSchemaHandler().ExecuteDDLScript(string.Format("TRUNCATE TABLE {0}", tableToTruncate));
        scope = ObjectScopeProvider1.GetNewObjectScope();
        //do something again

Hope that helps.

How to truncate table using Telerik OpenAccess ORM?

1 Answers1