public void Save(GmConnection conn) { GmCommand cmd = conn.CreateCommand(); cmd.AddInt("Id", id); cmd.AddInt("UserId", userId); cmd.AddString("Name", name); cmd.AddString("Data", data.GetXmlString()); if (id == 0) { cmd.CommandText = "insert into WatchingSchemes values (@UserId,@Name,@Data) select @@Identity"; id = (int)(decimal)cmd.ExecuteScalar(); } else { cmd.CommandText = "update WatchingSchemes set UserId=@UserId,Name=@Name,Data=@Data where Id=@Id"; cmd.ExecuteNonQuery(); } }