Update a table column value with a value which is unique

Question

I have a table like below FruitiId FrutName FroutGroupID(int) 1 mango 10 2 apple 10 3 banana 20 I want to update FroutGroupID with a value which is unique in that column using unit of work.

Gowtham Ramar · Answer

create table # temp ( FruitiId int , FrutName varchar (50), FroutGroupID int ) insert into # temp values (1, 'mango' ,10) insert into # temp values (2, 'apple' ,10) insert into # temp values (3, 'ora' ,20) update a set a.FrutName= '0' from # temp a join ( select FroutGroupID, count (1) fn from # temp group by FroutGroupID having count (1)=1) b on b.FroutGroupID=a.FroutGroupID select * from # temp

shafique ansari · Answer

Yes

Jefferson S. Motta · Answer

like this? https://stackoverflow.com/questions/25894587/how-to-update-record-using-entity-framework-6 using (var db = new MyContextDB()) { var result = db.Books.SingleOrDefault(b => b.BookNumber == bookNumber); if (result != null ) { result.SomeValue = "Some new value" ; db.SaveChanges(); } }

shafique ansari · Answer

Thanks for the update. We have to do it using unit of work, entity frame work. How can we acheive that?

Jefferson S. Motta · Answer

Dear Shafique: This updates with any value: update #temp SET FroutGroupID = 30 where FruitiId = 1; I setup 30. Best,

shafique ansari · Answer

Sorry for not clearing at first point.. My problem is How can we Update fruigroupid of any row with a value that does not exist in the table, means it should be 10 or 20 but it could be any value other than 10 or 20. Keeping concurrency in our mind too.