public static void DBCallGetArticleSP()
{
using (var context = new DatabaseFirst_PublishingCompany.PublishingCompanyEntities())
{
var ArtDet = context.GetArticle(9).ToList <DatabaseFirst_PublishingCompany.GetArticle_Result>();
foreach (DatabaseFirst_PublishingCompany.GetArticle_Result cs in ArtDet)
{
Console.WriteLine("ArticleID :{0}, Title : {1} , Body : {2}, AuthorID : {3}", cs.ArticleID, cs.Title, cs.Body, cs.AuthorID);
}
}
}
public static void DBCallGetNextAuthorSP()
{
using (var context = new DatabaseFirst_PublishingCompany.PublishingCompanyEntities())
{
ObjectResult <DatabaseFirst_PublishingCompany.GetNextAuthor_Result> orderDetailEnumerable = context.GetNextAuthor(2);
List <DatabaseFirst_PublishingCompany.GetNextAuthor_Result> details = orderDetailEnumerable.ToList();
foreach (DatabaseFirst_PublishingCompany.GetNextAuthor_Result dt in details)
{
Console.WriteLine("{0},{1},{2}", dt.AuthorID, dt.FirstName, dt.LastName);
}
}
}
public static void DBAddEntity()
{
using (var context = new DatabaseFirst_PublishingCompany.PublishingCompanyEntities())
{
var product = context.Articles.SingleOrDefault(p => p.ArticleID == 2);
var newArt = new DatabaseFirst_PublishingCompany.Article
{
ArticleID = 2,
Title = "EF Testing",
Body = "Entity Framework Testing",
AuthorID = 2
};
context.Articles.AddObject(newArt);
context.SaveChanges();
}
}
