public void TestLowerCaseNames()
{
var mapper = new SimpleCRUD.CachingNameResolver(new SimpleCRUD.LowercaseFormatter());
SimpleCRUD.SetColumnNameResolver(mapper);
SimpleCRUD.SetTableNameResolver(mapper);
int userId;
using (var c = GetOpenConnection())
{
var user = new User2 {
FirstName = "Jane", LastName = "Doe", ScheduledDayOff = DayOfWeek.Monday
};
c.Insert(user);
userId = user.Id;
var post = new Post2 {
Text = "My first post", Author = user
};
c.Insert(post);
}
using (var c2 = GetOpenConnection())
{
var user = c2.Get <User2>(userId);
Assert.IsNotNull(user);
user.FirstName.IsEqualTo("Jane");
user.LastName.IsEqualTo("Doe");
Assert.IsEqualTo((DayOfWeek)user.ScheduledDayOff, DayOfWeek.Monday);
var posts = c2.MultiQuery <Post2, User2, Post2>("select p.* ||| u.* " +
"from post2 p, user2 u " +
"where p.author_id = u.id", (p, u) =>
{
p.Author = u;
return(p);
});
Assert.IsTrue(posts.Any());
}
}
public IHttpActionResult Post2(Post2 p)
{
try
{
Exam exam = new Exam();
exam.ExamName = p.ExamName;
exam.CompanyID = (from c in oe.Companies where c.CompanyName == p.CompanyName select c.CompanyID).Single();
exam.Subject = p.Subject;
oe.Exams.Add(exam);
oe.SaveChanges();
Question question = new Question();
question.FileName = p.FileName;
question.ExamID = (from e in oe.Exams where e.ExamName == p.ExamName select e.ExamID).Single();
question.Level = p.Level;
question.Del = p.Del;
oe.Questions.Add(question);
oe.SaveChanges();
return(Ok(question.ExamID));
}
catch
{
return(Ok("error"));
}
}
