To Generate autoIncrement sequence in c#.

Question

Hello everyone,

I am trying to generate a  sequence number only when inserting the data to the  database  the code is like (PROJ_2018_000001).where i am trying to generate this by local methods and some cancatination.but i am unable to increment the sequence from the last sequence instead i the sequence is getting generated from (PROJ_2018_000001) by (PROJ_2018_000002) iteself.

 

how to generate the  next sequence by previous sequence instead by always (PROJ_2018_000001).

 

Thank you in advance.