title: Custom Auto-Generated Sequences with SQL Server
body: <p>I have an <code>Employee</code> table with an employee ID column <code>EmpID (nvarchar(5))</code>.</p>
  
  <p>This is how I insert data into the <code>Employee</code> table  </p>
  
  <pre><code> Employee obj = new Employee();
   obj.EmpID = ?
   DBContext.Employees.InsertOnSubmit(obj);
   DBContext.SubmitChanges();
  </code></pre>
  
  <p>I want to make <code>EmpID</code>'s value to   </p>
  
  <pre><code>00001  
  00002  
  00003  
  00004  
  ....
  ....    
  </code></pre>
  
  <p>How can I create such a custom auto-generated sequence likes this ?</p>