LinqToSql Queries instead of some SQL query

Question

SELECT * FROM register WHERE user_id LIKE 'a%'

SELECT * FROM register WHERE user_id LIKE '%m'

SELECT * FROM register WHERE user_id LIKE '%andru%'


SELECT R.name,C.country_name,S.state_name 
FROM register R JOIN country C ON R.country_id=C.country_id
JOIN state S  ON R.state_id=S.state_id

SELECT R.name,C.country_name,S.state_name 
FROM register R INNER JOIN country C ON R.country_id=C.country_id       
INNER JOIN state S ON R.state_id=S.state_id

Now i need LinqToSql Queries instead of these query

whathaveyoutried?

Eren Ersönmez
– Eren Ersönmez

2012-07-02 17:22:51 +00:00
Commented Jul 2, 2012 at 17:22 — Eren Ersönmez
– Eren Ersönmez, Commented Jul 2, 2012 at 17:22
@ErenErsönmez Agreed, and I like the link

lc.
– lc.

2012-07-02 17:23:54 +00:00
Commented Jul 2, 2012 at 17:23 — lc.
– lc., Commented Jul 2, 2012 at 17:23
Stabbing in the dark: Take a look at SqlMethods.Like

lc.
– lc.

2012-07-02 17:24:50 +00:00
Commented Jul 2, 2012 at 17:24 — lc.
– lc., Commented Jul 2, 2012 at 17:24
msdn.microsoft.com/en-us/library/bb386976.aspx

Justin Pihony
– Justin Pihony

2012-07-02 17:37:02 +00:00
Commented Jul 2, 2012 at 17:37 — Justin Pihony
– Justin Pihony, Commented Jul 2, 2012 at 17:37

Alex · Accepted Answer · 2012-07-02 18:09:05Z

1

var result = context.Registers.Select(x => x.StartsWith(foo)).ToList();

result = context.Registers.Select(x => x.EndsWith(foo)).ToList();

result = context.Registers.Select(x => x.Contains(foo)).ToList();

result = from register in context.Registers
         join state in context.States on register.state_id equals state.state_id
         select new { register.name, state.country_name, state.state_name }

Note, inner join and join function the same in SQL — thus no need to complicate.

edited Jul 2, 2012 at 18:09

answered Jul 2, 2012 at 17:25

Alex

35.5k5 gold badges81 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

LinqToSql Queries instead of some SQL query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related