static void Main(string[] args)
{
var dbContext = new RBSEntities();
var resources = dbContext.resource_list();
foreach (var c in resources)
{
Console.WriteLine(c.name);
}
//LINQ Syntax
var query =
from c in dbContext.Resources
where c.admin == true
join a in dbContext.Reservations on c.id_resource equals a.id_resource
select new { Name = c.name, Surname = c.surname, Event = a.@event };
foreach (var resource in query.ToList())
{
Console.WriteLine(resource.Name + "\t" + resource.Surname + "\t" + resource.Event);
}
//Extension methods
var person = dbContext.Resources.Where(c => c.admin == true).OrderBy(c => c.name).Select(c => new { Name = c.name, Surname = c.surname });
foreach (var p in person.ToList())
{
Console.WriteLine(p.Name + p.Surname);
}
Console.ReadKey();
}
public async Task <IHttpActionResult> GetAll()
{
try
{
var dbContext = new RBSEntities();
var resources = dbContext.resource_list();
return(Ok(resources));
}
catch (Exception)
{
throw;
}
}
