public virtual KitGroupType InsertKitGroupType(KitGroupType entity) { KitGroupType other = new KitGroupType(); other = entity; if (entity.IsTransient()) { string sql = @"Insert into KitGroupType ( [KitGroupTypeGUID] ,[Name] ,[DisplayOrder] ,[CreatedOn] ) Values ( @KitGroupTypeGUID , @Name , @DisplayOrder , @CreatedOn ); Select scope_identity()" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@KitGroupTypeID", entity.KitGroupTypeId) , new SqlParameter("@KitGroupTypeGUID", entity.KitGroupTypeGuid) , new SqlParameter("@Name", entity.Name) , new SqlParameter("@DisplayOrder", entity.DisplayOrder) , new SqlParameter("@CreatedOn", entity.CreatedOn) }; var identity = SqlHelper.ExecuteScalar(this.ConnectionString, CommandType.Text, sql, parameterArray); if (identity == DBNull.Value) { throw new DataException("Identity column was null as a result of the insert operation."); } return(GetKitGroupType(Convert.ToInt32(identity))); } return(entity); }