//SQL Server CE doesn't support stored procedures.
public void CallStoredProcedure()
{
using (var entities = new IdEntities())
{
var result = entities.MaxRoot();
}
}
public static void AssemblyCleanup()
{
using (var entities = new IdEntities())
{
if (entities.Database.Exists())
{
entities.Database.Delete();
}
}
}
public void CallStoredProcedure()
{
double result;
using (var entities = new IdEntities())
{
result = entities.MaxRoot().FirstOrDefault().GetValueOrDefault();
}
Assert.AreEqual(Math.Sqrt(TestSeeds), result);
}
//[TestInitialize]
//public void TestInitialize()
//{
// using (var entities = new IdEntities())
// {
// entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
// entities.Ids.RemoveRange(entities.Ids);
// entities.SaveChanges();
// for (var i = 1; i <= TestSeeds; ++i)
// {
// entities.Ids.Add(new Id { Value = i });
// }
// entities.SaveChanges();
// }
//}
//[TestMethod]
public static int ClearTable()
{
var recordCount = -1;
using (var entities = new IdEntities())
{
entities.Ids.RemoveRange(entities.Ids);
entities.SaveChanges();
}
using (var entities = new IdEntities())
{
recordCount = entities.Ids.Count();
}
return(recordCount);
//Assert.AreEqual(0, recordCount);
}
//[TestMethod]
public static int RemoveRecords(int recordsToRemove)
{
var recordCount = -1;
using (var entities = new IdEntities())
{
entities.Ids.RemoveRange(entities.Ids.Take(recordsToRemove));
entities.SaveChanges();
}
using (var entities = new IdEntities())
{
recordCount = entities.Ids.Count();
}
return(recordCount);
//Assert.AreEqual(TestSeeds - recordsToRemove, recordCount);
}
public void TestInitialize()
{
using (var entities = new IdEntities())
{
entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
entities.Ids.RemoveRange(entities.Ids);
entities.SaveChanges();
for (var i = 1; i <= TestSeeds; ++i)
{
entities.Ids.Add(new Id {
Value = i
});
}
entities.SaveChanges();
}
}
//[TestMethod]
public static int UpdateRecord(int testValue)
{
var actualValue = -1;
using (var entities = new IdEntities())
{
entities.Ids.First().Value = testValue;
entities.SaveChanges();
}
using (var entities = new IdEntities())
{
// ReSharper disable PossibleInvalidOperationException
actualValue = entities.Ids.First().Value.Value;
// ReSharper restore PossibleInvalidOperationException
}
//Assert.AreEqual(testUpdateValue, actualValue);
return(actualValue);
}
public void TestInitialize()
{
AppDomain.CurrentDomain.SetData("DataDirectory", AppDomain.CurrentDomain.BaseDirectory);
using (var entities = new IdEntities())
{
entities.Database.Log = s => System.Diagnostics.Debug.WriteLine(s);
entities.Ids.RemoveRange(entities.Ids);
entities.SaveChanges();
for (var i = 1; i <= TestSeeds; ++i)
{
entities.Ids.Add(new Id {
Value = i
});
}
entities.SaveChanges();
}
}
//[TestMethod]
public static int AddRecords(int offsetRecords)
{
var recordCount = -1;
var recordsToInsert = TestSeeds + offsetRecords;
using (var entities = new IdEntities())
{
for (var i = TestSeeds + 1; i <= recordsToInsert; ++i)
{
entities.Ids.Add(new Id {
Value = i
});
}
entities.SaveChanges();
recordCount = entities.Ids.Count();
}
return(recordCount);
//Assert.AreEqual(recordsToInsert, recordCount);
}
