How can I do that:

Set generator myGen to 1;

With a stored procedure it is not ossible, because it doesn't support set ....

Can I execute the sl direct in any way?

Thanks a lot.

If you are trying to update all the records in a table, why don't you use the following:

SelfServicing: YourEntityCollection.UpdateMulti(...);

Adapter: adapter.UpdateEntitiesDirectly(...);

I don't have an entity for the generator...

Without llbl I do it in this way:

FbConnection con = new FbConnection(adapter.ConnectionString); con.Open(); FbCommand cQuery = new FbCommand("set generator mygen to 1", con); cQuery.ExecuteNonQuery(); con.Close();

May I ask why you want to reset the sequence (generator) ?

You could obtain a connection, via DbUtils (selfservicing) or the DataAccessAdapter (via a derived class so you can access the CreateConnection method which you override ) and with that create a command and execute the statement.

I need the reset of the generator, because in my system I reset a number every year and in this way I create numbers like (I don't use these values for records!!!) like this:

06000<value from generator> 07000<value from generator>

Thank's for your answer. I will try it.