private static void CascadingInsert()
{
var db = new BlogDbContex();
var post = new Post
{
Title = "New Post Title Боби",
Date = DateTime.Now,
Body = "This post have comments and tags",
User = db.Users.First(),
Comments =
new[]
{
new Comment { Text = "Comment 1", Date = DateTime.Now },
new Comment
{
Text = "Comment 2",
Date = DateTime.Now,
User = db.Users.First()
}
},
Tags = db.Tags.Take(3).ToList()
};
db.Posts.Add(post);
db.SaveChanges();
}
private static void DeleteExsistingData()
{
var db = new BlogDbContex();
var lastPost = db.Posts.OrderByDescending(p => p.Id).First();
db.Comments.RemoveRange(lastPost.Comments);
lastPost.Tags.Clear();
db.Posts.Remove(lastPost);
db.SaveChanges();
Console.WriteLine($"Deleted post #{lastPost.Id}");
}
private static void CreateNewData()
{
var db = new BlogDbContex();
var post = new Post { Title = "New Title", Body = "New Post Body", Date = DateTime.Now };
db.Posts.Add(post);
db.SaveChanges();
Console.WriteLine("Post #{0} created.", post.Id);
}
private static void ExecuteSQL()
{
var db = new BlogDbContex();
var startDate = new DateTime(2016, 05, 19);
var endDate = new DateTime(2016, 06, 14);
var posts = db.Database
.SqlQuery<PostData>(
@"SELECT ID, Title, Date FROM Posts
WHERE CONVERT(date, Date)
BETWEEN {0} AND {1}
ORDER BY Date", startDate, endDate);
foreach (var p in posts)
{
Console.WriteLine($"#{p.ID}: {p.Title} ({p.Date})");
}
}
static void Main(string[] args)
{
// QueryData();
// CreateNewData();
// CascadingInsert();
// UpdateExistingData();
// DeleteExsistingData();
//ExecuteSQL();
var db = new BlogDbContex();
var authors = db.Users.SelectMany(user => user.Posts, (user, post) => new { user.UserName, user.FullName });
foreach (var author in authors)
{
Console.WriteLine("Full Name: {0}",author.FullName);
Console.WriteLine("Username: {0}",author.UserName);
}
}
private static void UpdateExistingData()
{
var db = new BlogDbContex();
var user = db.Users.Where(u => u.UserName == "maria").First();
user.PasswordHash = Guid.NewGuid().ToByteArray();
db.SaveChanges();
Console.WriteLine("User #{0} ({1}) has a new random password.", user.Id, user.UserName);
}
private static void QueryData()
{
var db = new BlogDbContex();
var posts = db.Posts.Select(
p => new { p.Id, p.Title, Comments = p.Comments.Count(), Tags = p.Tags.Count() });
Console.WriteLine("SQL query:\n{0}\n", posts);
foreach (var p in posts)
{
Console.WriteLine($"{p.Id} {p.Title} ({p.Comments} comments, {p.Tags} tags)");
}
}