在数据库中没有正确保存的对象
问题描述:
[Test]
public void Artist_gets_stored_properly()
{
using (ISession session = NHHelper.GetSession())
{
Artist artist = new Artist() { Name = "Somathilaka Jayamaha" };
artist.Songs = new List<Song>()
{
new Song(){Artist = artist, Name = "Manamaala girawu"},
new Song(){Artist = artist, Name = "Sende andura"},
new Song(){Artist = artist, Name = "Sunilwan nuwan"}
};
foreach (var s in artist.Songs)
{
session.Save(s);
}
session.Save(artist);
}
using (ISession session = NHHelper.GetSession())
{
Artist artist = session.Query<Artist>().Single(x => x.Name == "Somathilaka Jayamaha");
Assert.AreEqual(3, artist.Songs.Count);
Assert.AreEqual("Sende andura", artist.Songs[1].Name);
}
}
public class Artist
{
public virtual int Id { get; set; }
public virtual string Name { get; set; }
public virtual IList<Song> Songs { get; set; }
}
public class Song
{
public virtual int Id { get; set; }
public virtual string Name { get; set; }
public virtual string WebPath { get; set; }
public virtual string FilePath { get; set; }
public virtual bool Downloaded { get; set; }
public virtual Artist Artist { get; set; }
void Download(IDownloader downloader)
{
}
}
我有上面的测试用例,它在这一行失败:Assert.AreEqual(3, artist.Songs.Count);
。歌曲似乎没有得到保存。我使用自动映射,并在映射覆盖的集合字段中使用Cascade.All()
并关闭延迟。我不明白为什么这个测试失败。正如你所看到的,我手动保存了3首歌曲,尽管据我所知,当Cascade.All()
为Artist.Songs
字段时,我不需要这样做。有人能告诉我我做错了什么吗?谢谢。在数据库中没有正确保存的对象
MS SQLServer的2005,.NET 3.5,FluentNHibernate 1.2.0.712
答
你没有使用一个事务,你永远不会刷新会话。
你所得到的插入的唯一原因是因为你使用的是identity
发生器,当你调用Save
(这是一个限制,而不是功能)的插入。
正确的方法,以这样的:
using (ISession session = NHHelper.GetSession())
using (var transaction = session.BeginTransaction())
{
Artist artist = new Artist { Name = "Somathilaka Jayamaha" };
artist.Songs = new List<Song>()
{
new Song{Artist = artist, Name = "Manamaala girawu"},
new Song{Artist = artist, Name = "Sende andura"},
new Song{Artist = artist, Name = "Sunilwan nuwan"}
};
session.Save(artist);
transaction.Commit();
}
+1
确实;一些有趣的内容:http://stackoverflow.com/questions/43320/nhibernate-isession-flush-where-and-when-to-use-it-and-why – 2012-03-12 12:43:49
什么是你的刷新模式设置为? 'FlushMode。?' – Rippo 2012-03-12 08:12:43
另外你如何处理交易? – Rippo 2012-03-12 08:29:28