private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (isLoaded == true)
{
var context = builder.Create(conn);
context.ContextOptions.LazyLoadingEnabled = true;
int id = (int)listBox1.SelectedValue;
label1.Text = id.ToString();
var query = from emp in context.Employee
where emp.Contact.ContactID == id
select emp;
dataGridView1.DataSource = query;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
if (ex.InnerException != null)
{
MessageBox.Show(ex.InnerException.Message);
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
conn = new SqlConnection("Data Source=SCOTT-LAPTOP;Initial Catalog=EF40;User ID=sa;PWD=Yamahayz1;MultipleActiveResultSets=True;");
builder = new ContextBuilder <AWModel>();
Registerconfig(builder);
var context = builder.Create(conn);
context.ContextOptions.LazyLoadingEnabled = true;
var query = from c in context.Contact
join emp in context.Employee on c.ContactID equals emp.Contact.ContactID
//where c.LastName.StartsWith("G")
orderby c.FirstName
select new { c.ContactID, c.FirstName, c.LastName };
isLoaded = false;
listBox1.DataSource = query;
listBox1.DisplayMember = "FirstName";
listBox1.ValueMember = "ContactID";
isLoaded = true;
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
if (ex.InnerException != null)
{
MessageBox.Show(ex.InnerException.Message);
}
}
}
private void Form1_Load(object sender, EventArgs e)
{
try
{
SqlConnection conn = new SqlConnection("Data Source=SCOTT-LAPTOP;Initial Catalog=EF40;User ID=sa;PWD=Yamahayz1;MultipleActiveResultSets=True;");
var builder = new ContextBuilder <AWModel>();
Registerconfig(builder);
var context = builder.Create(conn);
//var query = from r in context.SalesTerritory
// select r;
//foreach (var per in query)
//{
// listBox1.Items.Add(per.Name);
//}
var query = from emp in context.Employee
select emp;
foreach (var empl in query)
{
listBox1.Items.Add(empl.LoginID);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
if (ex.InnerException != null)
{
MessageBox.Show(ex.InnerException.Message.ToString());
}
}
}
/// <summary>
/// Query the TPH inheritance entities
/// </summary>
/// <param name="builder">The certain ContextBuilder to create the
/// ObjectContext</param>
/// <param name="conn">The certain SqlConnection to connect the
/// SQL Server Express</param>
static void QueryTPHData(ContextBuilder <CodeOnlyContainer> builder,
SqlConnection conn)
{
// Create the ObjectContext object by the ContextBuilder and
// SqlConnection
using (CodeOnlyContainer context = builder.Create(conn))
{
// Query and display the TPH inheritance entities
Console.WriteLine("Display People (TPH):");
foreach (var peopleTPH in context.PeopleTPH)
{
// Check if it is the Admin type
if (peopleTPH is AdminTPH)
{
var admin = (AdminTPH)peopleTPH;
Console.WriteLine("Admin:");
Console.WriteLine(
"ID: {0}, Name: {1}, AdminDate: {2}",
admin.PersonID, admin.Name, admin.AdminDate);
}
// Check if it is the Student type
else if (peopleTPH is StudentTPH)
{
var student = (StudentTPH)peopleTPH;
Console.WriteLine("Student:");
Console.WriteLine(
"ID: {0}, Name: {1}, EnrollmentDate: {2}",
student.PersonID, student.Name,
student.EnrollmentDate);
}
// Check if it is the Instructor type
else if (peopleTPH is InstructorTPH)
{
var instructor = (InstructorTPH)peopleTPH;
Console.WriteLine("Instructor:");
Console.WriteLine(
"ID: {0}, Name: {1}, HireDate: {2}",
instructor.PersonID, instructor.Name,
instructor.HireDate);
}
}
}
}
static void Main(string[] args)
{
//Note this wont work at time of writing due to EF add on not being available for RC yet
var ctxBuilder = new ContextBuilder <FilmModel>();
ctxBuilder.Configurations.Add(new FilmConfiguration());
var ctx =
ctxBuilder.Create(new SqlConnection(
"server=localhost;UID=USERNAME;PWD=PASSWORD; database=book;Pooling=true")
);
var NewFilm =
new Film {
Description = "Code only", Length = 200, Title = "Total Recall"
};
ctx.Film.AddObject(NewFilm);
ctx.SaveChanges();
ctx.Dispose();
}
/// <summary>
/// Create the database based on EDM metadata, then insert and query
/// relational entities
/// </summary>
/// <param name="builder">The certain ContextBuilder to create certain
/// ObjectContext</param>
/// <param name="conn">The certain SqlConnection to connect the
/// SQL Server Express</param>
static void CreateDatabaseAndInsertQueryEntities(
ContextBuilder <CodeOnlyContainer> builder, SqlConnection conn)
{
// Create the ObjectContext object by the ContextBuilder and
// SqlConnection
using (CodeOnlyContainer context = builder.Create(conn))
{
// Check if the database exists
if (context.DatabaseExists())
{
// Delete it if it exists
context.DeleteDatabase();
}
// Create the database
context.CreateDatabase();
// Create a new Type-per-Table(TPT) inheritance Admin entity
AdminTPT admin = new AdminTPT()
{
// PK value
PersonID = 1,
// Two Complex Types properties, Name and Address
Name = new Name()
{
FirstName = "Jialiang",
LastName = "Ge"
},
Address = new Address()
{
City = "Shanghai",
Country = "China",
Zipcode = "200030"
},
AdminDate = DateTime.Now
};
// Add the newly created Admin entity into the ObjectContext
context.PeopleTPT.AddObject(admin);
// Create a new Deparment entity
Department department = new Department()
{
// PK value
DepartmentID = 1,
Name = "Computer Science",
Budget = 400000,
StartDate = DateTime.Now
};
// Create a new Course entity
Course course = new Course()
{
// PK value
CourseID = 1001,
Title = ".NET Framework",
Credits = 3,
// Set the relational entity by navigation property
Department = department,
// Initialize the Instructors navigation property
Instructors = new List <InstructorTPT>()
};
// Create a new TPT inheritance Instructor entity
InstructorTPT instructor = new InstructorTPT()
{
// PK value
PersonID = 2,
// Two Complex Types properties, Name and Address
Name = new Name()
{
FirstName = "Colbert",
LastName = "Zhou"
},
Address = new Address()
{
City = "Shanghai",
Country = "China",
Zipcode = "200030"
},
HireDate = DateTime.Now
};
// Add the newly created Instructor entity into the
// Course's Instructor collection
course.Instructors.Add(instructor);
// Create a new TPT inheritance Student entity
StudentTPT student = new StudentTPT()
{
// PK value
PersonID = 3,
// Two Complex Types properties, Name and Address
Name = new Name()
{
FirstName = "Lingzhi",
LastName = "Sun"
},
Address = new Address()
{
City = "Shanghai",
Country = "China",
Zipcode = "200032"
},
EnrollmentDate = DateTime.Now
};
// Create a new CourseStudent relationship entity
CourseStudent courseStudent = new CourseStudent()
{
// Set the navigation properties
Student = student,
Course = course,
Score = 90
};
// Add the CourseStudent relationship entity into the
// ObjectContext
context.CourseStudents.AddObject(courseStudent);
// Create a new Type-per-Hierarchy(TPH) inheritance Admin
// entity
AdminTPH adminTPH = new AdminTPH()
{
// PK value
PersonID = 1,
// Two Complex Types properties, Name and Address
Name = new Name()
{
FirstName = "Jialiang",
LastName = "Ge"
},
Address = new Address()
{
City = "Shanghai",
Country = "China",
Zipcode = "200032"
},
AdminDate = DateTime.Now
};
// Create a new TPH inheritance Instructor entity
InstructorTPH instructorTPH = new InstructorTPH()
{
// PK value
PersonID = 2,
// Two Complex Types properties, Name and Address
Name = new Name()
{
FirstName = "Colbert",
LastName = "Zhou"
},
Address = new Address()
{
City = "Shanghai",
Country = "China",
Zipcode = "200030"
},
HireDate = DateTime.Now
};
// Create a new TPH inheritance Student entity
StudentTPH studentTPH = new StudentTPH()
{
// PK value
PersonID = 3,
// Two Complex Types properties, Name and Address
Name = new Name()
{
FirstName = "Lingzhi",
LastName = "Sun"
},
Address = new Address()
{
City = "Shanghai",
Country = "China",
Zipcode = "200032"
},
EnrollmentDate = DateTime.Now
};
// Add the TPH inheritance entities into the ObjectContext
context.PeopleTPH.AddObject(adminTPH);
context.PeopleTPH.AddObject(instructorTPH);
context.PeopleTPH.AddObject(studentTPH);
try
{
// Saving the relational entities
Console.Write("Saving the relational entities...");
context.SaveChanges();
Console.WriteLine("Successfully!");
}
catch (Exception ex)
{
Console.WriteLine("Failed!");
Console.WriteLine(ex.ToString());
}
// Query the single Course entitiy from the ObjectContext
var queryCourse = context.Courses.Single();
// Display the Course informaion
Console.WriteLine("Course: {0} under Department: {1}",
queryCourse.Title, queryCourse.Department.Name);
Console.WriteLine();
// Query and display the Course's Instructors information
Console.WriteLine("Course Instructors:");
foreach (var i in queryCourse.Instructors)
{
Console.WriteLine(i.Name);
}
Console.WriteLine();
// Query and display the Course's Students information
Console.WriteLine("Course Students:");
foreach (var cs in queryCourse.CourseStudents)
{
Console.WriteLine(cs.Student.Name);
}
}
}