Question

我们正在修改我们关于停滞不前的职位。

我们只修改了tags part,removed tag1/code>,tag2,并添加了tag3,>tag4。



在要求Post You Questionthton之后,应当做以下工作:


reduced the count column for tag1,tag2 by 1
delete the relation between the post and tag1,tag2
if tag3,tag4 already exists,increase the count column of the two by 1;otherwise,insert them to the tags table with count value 1
add the relation between the post and tag3,tag4


让我们呼吸深厚的 and!

我想看到,无论在PHP/Java/C/文件中写到什么事项,哪一个办公室能够最容易地处理这一问题。 各种语言的内含或外任何语言都相似!

Answer 1

http://dataobjects.net/“rel=“nofollow noretinger”>DataObjects.Net。它将这样做。现在没有任何绘图档案,因为数据库图象自动由人力资源管理厅生成,包括问答关系的附属表格。

4. 食堂:

[HierachyRoot]
public class Tag : Entity
{
  [Field, Key]
  public int Id { get; private set; }

  [Field(Length = 100, Indexed = true)]
  public string Name { get; private set; }

  [Field]
  public int QuestionsCount { get; set; }

  public Tag(string name) 
  {
    Name = name;
  }
}

问题类别:

[HierachyRoot]
public class Question : Entity
{
  [Field, Key]
  public int Id { get; private set; }

  [Field]
  public EntitySet<Tag> Tags { get; private set; }

  // Business methods (can be placed in separate service class)

  public void AddTag(string name)
  {
    var tag = Query.All<Tag>().SingleOrDefault(t => t.Name == name);
    if (tag==null)
      tag = new Tag(name) { QuestionsCount = 1 }
    else
      tag.QuestionsCount++;
    Tags.Add(tag);
  }

  public void RemoveTag(string name)
  {
    var tag = Query.All<Tag>.Single(t => t.Name == name);
    tag.QuestionsCount--;
    Tags.Remove(tag);
  }
}

申请代码:

using (Session.Open())
using (var transactionScope = Transaction.Open())
{
  var question = Query.Single<Question>(questionId);

  question.RemoveTag("tag1");
  question.RemoveTag("tag2");

  question.AddTag("tag3");
  question.AddTag("tag4");

  transactionScope.Complete();
}

友情链接