static void Main(string[] args)
{
using (var db = new BloggingContext())
{
// Create and save a new Blog
Console.Write("Enter Username: "******"Enter a name for a new Blog: ");
var blogName = Console.ReadLine();
Console.Write("Enter a name for a new Organisation: ");
var orgName = Console.ReadLine();
//Create entities
var organization = new Organization { OrganizationName = orgName };
var user = new User { Username = userName, Organization = organization };
var blog = new Blog { Name = blogName };
db.Users.Add(user);
db.Organizations.Add(organization);
db.Blogs.Add(blog);
db.SaveChanges();
// Query all Blogs from the database
var blogQuery = from b in db.Blogs
orderby b.Name
select b;
// Query all Users from the database
var userQuery = from u in db.Users
orderby u.Username
select u;
// Query all Users from the database
var orgQuery = from o in db.Organizations
orderby o.OrganizationName
select o;
Console.WriteLine("All blogs in the database:");
foreach (var item in userQuery)
{
Console.WriteLine(item.Username + " is a member of the organization: " + item.Organization.OrganizationName);
}
}
}
static void Main(string[] args)
{
using (var db = new BloggingContext())
{
// Create and save a new Blog
Console.Write("Enter a name for a new Blog: ");
var name = Console.ReadLine();
var blog = new Blog { Name = name };
db.Blogs.Add(blog);
Console.Write("Enter a name for a new Organization ");
var organizationName = Console.ReadLine();
var organization = new Organization { OrganizationName = organizationName };
db.Organizations.Add(organization);
Console.Write("Enter a users name to add to the organization ");
var userName = Console.ReadLine();
var user = new User
{
Username = userName,
Organization = organization
};
db.Users.Add(user);
db.SaveChanges();
// Display all Blogs from the database
var query = from b in db.Blogs
orderby b.Name
select b;
var query2 = from b in db.Users
orderby b.Username
select b;
Console.WriteLine("All blogs in the database:");
foreach (var item in query)
{
Console.WriteLine(item.Name);
}
Console.WriteLine("Users and organizations ");
foreach (var item in query2)
{
Console.WriteLine(item.Username + " works in " + item.Organization.OrganizationName);
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}