how transform unparalleled buttress linq but loading whole row?
in linqtosql, elegant easy bucket row, change column, quarrel changes database:
using (mydatacontext wdc = new mydatacontext())
{
essay article = wdc.article.first(p => p.id == id);
article.itemsinstock = itemsinstock;
wdc.submitchanges();
}
the wholly drawback: essay huge. to bucket whole article, only transform buttress proceed overkill slows down app significantly.
is there proceed transform unparalleled buttress controlling linq, but carrying bucket whole row?
right i return controlling executecommand where speed essence, nonetheless dizzy blunder prone:
wdc.executecommand("update essay set itemsinstock = @1 where id = @2", itemsinstock,id);
Comments
Post a Comment