C# 3.0 Lambdas

[Suzi167]

Hello,

I need to write a LINQ expression to remove all the entries from my VqEmSampleSchedules table which have their VqEmTestByLocationId == to the id I have passed to that function.
I have all my mappings working and I have entities with the same names as the tables.
I have the following expression which is not compiling:



EnvironmentalMonitoringModelUnitOfWork uow = new EnvironmentalMonitoringModelUnitOfWork();
uow.Remove(uow.VqEmSampleSchedules.Select( s => s.VqEmTestByLocationId=id));



I am new to LINQ and to lambdas so any help is very appreciated.

Thanks

Susan

[BigEd781]

You are using an assignment operator instead of an equality operator.


uow.Remove(uow.VqEmSampleSchedules.Select( s => s.VqEmTestByLocationId=id));


Should be


uow.Remove(uow.VqEmSampleSchedules.Select( s => s.VqEmTestByLocationId == id));


Notice the extra '=' sign? Also, it always helps to look at and post the compiler error.

[Suzi167]

Oh... :) thanks for the correction... but unfortunately there is something else wrong with the query I have.
Let me make it a bit more general

What is the LINQ expression to remove certain records from an entity. For example if I have a table/entity called user I need to write a LINQ expression to remove all users with last name Smith.
How can I do that.

Thanks

Susan

[Suzi167]

I found an answer even though it's not a one-line solution it's a good one that works.



EnvironmentalMonitoringModelUnitOfWork uow = DataService.Context.CreateUnitOfWork();
//select all the entries with the id of that template
var scheduleEntries = from scheduleEntry in uow.VqEmSampleSchedules where scheduleEntry.VqEmTestByLocationId == id select scheduleEntry;
foreach (VqEmSampleSchedule sample in scheduleEntries)
uow.Remove(sample);
uow.SaveChanges();
return RedirectToAction("Calendar");




Susan