StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>I am hoping you can help. I am developing a tiered website using Linq to Sql. I created a new class(or object) in DBML designer called memberState. This object is not an actual table in the database. I have this method in my middle layer:<br/><br/></p> <pre><code>public override IEnumerable(memberState) GetMembersByState(string @state)<br/> {<br/> using (BulletinWizardDataContext context = DataContext)<br/> {<br/> IEnumerable(memberState) mems = (from m in context.Members<br/> join ma in context.MemberAddresses<br/> on m.UserId equals ma.UserId<br/> join s in context.States<br/> on ma.StateId equals s.StateId<br/> where s.StateName == @state<br/> select new memberState<br/> {<br/> userId = m.UserID,<br/> firstName = m.FirstName,<br/> middleInitial = m.MiddleInitial,<br/> lastName = m.LastName,<br/> createDate = m.CreateDate,<br/> modifyDate = m.ModifyDate<br/> }).ToArray(memberState)();<br/> return mems; } } </code></pre> <p>The tables in my joins (Members, States, and MemberAddresses are actual tables in my Database). I created the object memberStates so I could use it in the query above (notice the <b>Select New memberState</b>. When the data is updated on the web page how do I persist the changes back to the Member Table? My Member Table consists of the following columns: UserId, FirstName, MiddleInitial, LastName, CreateDate, ModifyDate. I am not sure how save the changes back to the database.<br/><br/> </p> <p>Thanks,</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload