How Select from table using linq

Question

0.00/5 (No votes)

See more:

How can i select last conversation messages to users From below table of Id 1 that may be in FromId or ToId

CSS

MessageId  FromId  ToId Message      Time                  Status

19            1     5   hiii    2013-07-05 16:39:49.727     New
21            5     1   message   2013-07-10 11:19:53.733    New
25            5     1   dfdfdf  2013-07-07 00:00:00.000     New
29            1     8    dsfas    2013-07-07 00:00:00.000    New
30            8     1   asdfjas   2013-07-07 02:00:00.000   New

Required Output:-

XML

MessageId  FromId  ToId Message      Time                  Status

21            5     1   message   2013-07-10 11:19:53.733    New
30            8     1   asdfjas   2013-07-07 02:00:00.000   New

Posted 15-Jul-13 1:41am

Jithin Geroge

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Answer 1 · 2013-07-15T02:38:00

Solution 2

C#

var ResultData = from Data in db.TableName
                 where Data.FromId==1
                 select Data;

where db=DataclassDataContext()

All the data regarding your ID is in ResultData variable....:)

Posted 15-Jul-13 2:38am

Nirav Prabtani

Updated 15-Jul-13 2:39am

v2

Comments

Jithin Geroge 15-Jul-13 9:01am

Above table is message table it contain users from messages and to messages . It seperated by FromId and ToId . I need last conversation of particular user say user with id= 1 to different users that Id=1 sended or received messages. How can i select??

Nirav Prabtani 15-Jul-13 9:04am

what r u saying i can not understand???

Jithin Geroge 15-Jul-13 9:12am

Very recent conversations by date of User with id=1

Nirav Prabtani 15-Jul-13 9:15am

then you have to select max date from table... :)

Jithin Geroge 15-Jul-13 9:32am

Sorry .. please give a brief example..

**Joezer BH** · Answer 2 · 2013-07-15T02:26:00

Solution 1

A simple linq query that selects the rows where the ToId equals 1 (as in your "required output")

C#

DateTime start = new DateTime("1/1/2013");
var result = (from a in new YourDataContext().YourTableName
              where ((a.ToId == 1 || a.FromId == 1) && a.Time >= start)
              select a);

If it's not what you intended, explain a little more, and we will provide ;)

Good luck,
Edo

Posted 15-Jul-13 2:26am

Joezer BH

Updated 15-Jul-13 3:19am

v2

Comments

Jithin Geroge 15-Jul-13 9:01am

Above table is message table it contain users from messages and to messages . It seperated by FromId and ToId . I need last conversation of particular user say user with id= 1 to different users that Id=1 sended or received messages. How can i select??

Joezer BH 15-Jul-13 9:12am

In your example above the results are from two different users (5 and 8):

MessageId FromId ToId Message Time Status

21 5 1 message 2013-07-10 11:19:53.733 New
30 8 1 asdfjas 2013-07-07 02:00:00.000 New

Jithin Geroge 15-Jul-13 9:14am

Very recent conversations by date of User with id=1 , Id may be in FromId or in toId according to received message or sent message

Joezer BH 15-Jul-13 9:20am

OK updated the solution above to accomodate,
Good luck,
Edo ;)

Jithin Geroge 15-Jul-13 9:35am

I tried with above query.. I getting message from date 1/1/2013 .
But I need not that.. I need Very recent conversations by date of User with id=1