how to write a queryto update values in sqlserver from cs file

See more:

C#

SQL-Server

Hi,

I have a table base that have the colums family,cachefamily, userid, timestamp etc..

and another table monitor table : app_id, attribute_name,sourcetype etc..

2nd table column ,attribute_name contains the values as cachefamily, line_no etc..

now i need to write a query to get the family from the cachefamily in baserepository.cs file..


how can i write the query for this in .cs file..

I am very new to this one .. please help me any one..