Link to home
Start Free TrialLog in
Avatar of Tom Knowlton
Tom KnowltonFlag for United States of America

asked on

LINQ to DataSet - perform an insert or update - in C# syntax

Trying to learn LINQ:

DataSet ds = DataHelper.ReturnDataSet("select * from llpp_users");

            DataTable dt = ds.Tables[0];

            var query =
                    from o in dt.AsEnumerable()
                    where o.Field<string>("email") == email
                    && o.Field<string>("password") == password
                    select o;

            int count = query.Count();

            if (count == 1)
            {
                Response.Write(query.ElementAt(0).Field<string>("username") + " is signed in.");
            }


This seems to work........but how do I do an INSERT or an UPDATE using LINQ syntax  (notice that I am using LINQ to DataSet)
ASKER CERTIFIED SOLUTION
Avatar of lazyberezovsky
lazyberezovsky
Flag of Belarus image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Tom Knowlton
Tom Knowlton
Flag of United States of America image

ASKER

Oh....

Uh....  okay.
Avatar of lazyberezovsky
lazyberezovsky
Flag of Belarus image
Hi, knowlton

Sorry, I was not complete about this. You can change data in your DataTable via calling SetField method.
E.g:

foreach (var row in query)
    row.SetField<string>("email", "test@mail.com");

After that you can insert/update data from your DataSet to database via DataAdapter.