static void Main(string[] args)
{
using (SoftUniEntities softuniDbContextFirst = new SoftUniEntities())
{
using (SoftUniEntities softuniDbContextSecond = new SoftUniEntities())
{
softuniDbContextSecond.Addresses.Find(3).AddressText = "Vasil Levski Str. 15";
softuniDbContextFirst.Addresses.Find(3).AddressText = "BulairStr 25";
softuniDbContextSecond.SaveChanges();
softuniDbContextFirst.SaveChanges();
}
}
using (SoftUniEntities softuniDbContext = new SoftUniEntities())
{
string addressText = softuniDbContext.Addresses.Find(3).AddressText;
Console.WriteLine(addressText);
}
}
// Task 09.
// Stored procedure usp_GetProjectsCountByEmployee has been created in SQL SERVER
// EF Models were updated with the new stored procedure
/// <summary>
/// Method returns the total count of the projects for all found Employees with the given names.
/// </summary>
/// <param name="firstName">Employee FirstName</param>
/// <param name="lastName">Employee LastName</param>
/// <returns>Zero - If no employee with the given names is found; Zero - If the given Employee has no projects</returns>
public static int GetProjectsCountByEmployee(string firstName, string lastName)
{
using (SoftUniEntities softuniDbContext = new SoftUniEntities())
{
var projectsCount = softuniDbContext.usp_GetProjectsCountByEmployee(firstName, lastName).FirstOrDefault();
return projectsCount.Value;
}
}