Update a table column value with a value which is unique

shafique ansari

7y912

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.

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

shafique ansari7y ago
Yes
0
Jefferson S. Motta7y ago
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();
    }
}
0
shafique ansari7y ago
Thanks for the update. We have to do it using unit of work, entity frame work. How can we acheive that?
0
Jefferson S. Motta7y ago
Dear Shafique:

This updates with any value:

update #temp SET FroutGroupID = 30 where FruitiId = 1;

I setup 30.

Best,
0
shafique ansari7y ago
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.
0
Gowtham Ramar7y ago
1. create table #temp
2. (
3. FruitiId int,
4. FrutName varchar(50),
5. FroutGroupID int)
8. insert into #temp values (1,'mango',10)
9. insert into #temp values (2,'apple',10)
10. insert into #temp values (3,'ora',20)
12. update a set a.FrutName='0' from #temp a
13. join (
14. select FroutGroupID,count(1) fn from #temp group by FroutGroupID having count(1)=1) b on b.FroutGroupID=a.FroutGroupID
17. select * from #temp
+1