00001 00002 using System; 00003 using NUnit.Framework; 00004 using Foodolini.Database; 00005 00006 namespace Foodolini.Database.Test 00007 { 00008 00012 [TestFixture] 00013 public class RecipeRowTest : DatabaseTest 00014 { 00019 [Test] 00020 public void SaveLoadTest () 00021 { 00022 RecipeRow recipe = new RecipeRow(); 00023 recipe.AverageRating = 9.8; 00024 recipe.Difficulty = 1; 00025 recipe.PictureId = null; 00026 recipe.PreparationTime = 30; 00027 recipe.Servings = 60.0; 00028 recipe.Title = "Sloppy Joe"; 00029 00030 this.repository.Add<RecipeRow>(recipe); 00031 00032 Assert.AreNotEqual(0, recipe.RecipeRowId, "RecipeRowId is 0"); 00033 00034 RecipeRow r = this.repository.SingleWhere<RecipeRow>("RecipeRowId = @0", recipe.RecipeRowId); 00035 00036 Assert.AreEqual(9.8, r.AverageRating); 00037 Assert.AreEqual(1, r.Difficulty); 00038 Assert.AreEqual(null, r.PictureId); 00039 Assert.AreEqual(30, r.PreparationTime); 00040 Assert.AreNotEqual(null, r.PreparationTime, "PreperationTime is null!"); 00041 Assert.AreEqual(60.0, r.Servings); 00042 Assert.AreEqual("Sloppy Joe", r.Title); 00043 } 00044 } 00045 }