create trigger tr_NextIDItem on Item for insert as begin DECLARE @lastIDItem varchar(6) SET @lastIDItem = (SELECT TOP 1 IDItem from Item order by IDItem desc) UPDATE Item set IDItem = dbo.func_NextIDItem (@lastIDItem,'IT_',6) where IDItem = '' end
context.Item.Add(_item); context.SaveChanges();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)