TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
darma teja
NA
496
336.4k
write Linq for xmlDatatype-column
Jul 17 2019 4:17 AM
I have an xmldatatype column(name: xmlColumn) in tbCustomer Tabel. now I want to retrive in xmlColumn where /Address/street/No/text() in (1, 2, 3)
I can write it in SQL
where
xmlColumn.value(
'(/Address/street/No/text())[1]'
,
'INT'
)
IN
(1, 2, 3) // It works fine
in
sql editor
I wanted to include the above conditon in the following LINQ expression:
var dataSource = from c
in
tbCustomer
join o
in
tbOrder on c.custID = o.custid
select
new
{ c.custID,
c.custtname,
o.ordername
}
Reply
Answers (
1
)
Check Id exists in websevice method content
How do I combine 2 lists into one in linq?