Best way to update a single field in all Entities?

Hi,

I need to reset a counter (int) field to 0 in all instances of my "Content" entities. What is the best way to do this?

I have thought of..

1) TList using "GetAll" from ContentService, and setting the property=0 for the entire list. But I'm not sure if there is a short cut or if I need to iterate through the entire list to set the values.

2) Executing a SQL Query using:
DataRepository.Provider.ExecuteNonQuery(CommandType.Text, "UPDATE Content SET Counter=0");

TIA for any recommendations.

This is a perfect spot for a custom proc.  Sql Server does this much better than C#. 

1.  You could create a function in the Content data repositoty that updated the value and called ExecuteNonQuery.  I would not put the Sql in anywhere other than the data layer.

2.  Write a custom procedure from your Content table.  The proc would just update them all to 0.  Then, Nettiers will create the method for you.  This is what I would do.

jeff

Just be careful to follow your patern of development. If you're creating SPs for every single stuff you need, then creating a procedure as jeff suggested is the way to go. If you have no idea of what we're talking about OR has the option ExecuteSql set to false, then it would be better to create a method in your DA class to handle that for you.

I would create a method in my DataLayer... but that's just because I hate SP's... (;

Thanks for your ideas.. I think I go with a method in the DAL, since I haven't been using a lot of SP's

Yeah! SP's s**ks!!

lol

Lol, at least I mentioned both methods!