Comments by harikakakkireni (Top 4 by date)

Chowdary,
i am not sure if you are able to understand it correctly,
let me change the variable names little and try to edit the code

string[] allPracticeIDsOfUser = users.ElementAt(0).Practices.Split(new char[] { ',' });


AuthenticationEntities authEntity = new AuthenticationEntities();



List<Practices> prac = (from p in authEntity.Practices
where allPracticeIDsOfUser.Contains (p.PracticeID.ToString())
select new Practices
{
Practice = p.PracticeName
}).ToList<Practices>();

Hope this helps

Chowdary,

can you tell me what actually is present in Practices?

string[] Practices = users.ElementAt(0).Practices.Split(new char[] { ',' });

this above line of code does it return you all the id's?

if yes,

then you need not make string [] as string by appending it with ,

just try this

string[] Practices = users.ElementAt(0).Practices.Split(new char[] { ',' });


AuthenticationEntities authEntity = new AuthenticationEntities();



List<Practices> prac = (from p in authEntity.Practices
where Practices.Contains (p.PracticeID.ToString())
select new Practices
{
Practice = p.PracticeName
}).ToList<Practices>();

are you using entity framework or enterprise library? and do u mean linq to sql?????


and you can check

http://stackoverflow.com/questions/909960/update-using-linq for some samples

http://weblogs.asp.net/scottgu/archive/2007/07/11/linq-to-sql-part-4-updating-our-database.aspx