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();
}
}
static void Main(string[] args)
{
using (var db = new BloggingContext())
{
//Kontrol af Punkt 21 om det virkede
var o_query = from o in db.Organizations
orderby o.OrganizationId
select o;
foreach (var o_item in o_query)
{
Console.WriteLine("Org: " + o_item.OrganizationName + " Homeland 1: " + o_item.Homelands[0].CountryName + " Homeland 2: " + o_item.Homelands[1].CountryName + " Homeland 3: " + o_item.Homelands[2].CountryName);
}
// Create og save en ny Blog
Console.Write("Enter a name for a new Blog: ");
var name = Console.ReadLine();
//Add et nyt navn til bloggen DB
var blog = new Blog {
Name = name
};
db.Blogs.Add(blog);
db.SaveChanges();
//Udvidelse af organizationsnavn
Console.WriteLine("Please enter a new organization name.");
var orgname = Console.ReadLine();
//Add nyt navn til organizationstabellen
var org = new Organization {
OrganizationName = orgname
};
db.Organizations.Add(org);
db.SaveChanges();
//Fรฆrdig med fรธrste udvidelse
//Anden udvidelse, tilsรฆt brugernavn til organisationen (tror jeg)
Console.WriteLine("Enter your username, it will be added to the org");
var username = Console.ReadLine();
//Add nyt navn til brugertabellen
var user = new User {
Username = username, Organizations = org
}; //Tilfรธjer med reference organizations = org
db.Users.Add(user);
db.SaveChanges();
// Display alle Blogs fra database
var query = from b in db.Blogs
orderby b.Name
select b;
Console.WriteLine("All blogs in the database:");
foreach (var item in query)
{
Console.WriteLine(item.Name);
}
//Punkt 8, udskriv alle bruger og organizationer
var u_query = from u in db.Users
orderby u.Username
select u;
Console.WriteLine("Usernames, organizations and orgID");
foreach (var u_item in u_query)
{
Console.WriteLine("User: "******" Org: " + u_item.Organizations.OrganizationName + " Org ID: " + u_item.Organizations.OrganizationId);
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
