Linq Queries - Update data in query
how to update an item in a list by linq
public static class UpdateExtensions
{
public delegate void Func<TArg0>(TArg0 element);
public static int Update<TSource>(this IEnumerable<TSource> source, Func<TSource> update)
{
if (source == null) throw new ArgumentNullException("source");
if (update == null) throw new ArgumentNullException("update");
if (typeof(TSource).IsValueType)
throw new NotSupportedException("value type elements are not supported by update.");
int count = 0;
foreach (TSource element in source)
{
update(element);
count++;
}
return count;
}
}
Use update extension
var Datas = from ev in db.Events
join ea in db.EventAttendees on ev.EventId equals ea.EventId
where ea.UserId == userid
select new VMEvent
{
EventName = ev.EventName,
EventAttendeeSubmittedDate = ea.SubmittedDate.ToString(),
Place = ev.Place,
EventAttendeeNoofMembers = ea.noofMembers.ToString()
};
var query = (from items in Datas
select items)
.Update(st => { st.EventDateString = st.EventDate.ToString("dd/M/yyyy", CultureInfo.InvariantCulture); });
Enjoy !!!
:)
No comments:
Post a Comment