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
Guest User
Tech Writer
611
127.9k
Get Record From Two table .
Sep 30 2020 4:45 AM
How to get record from two table using linq c# .It's my code i have use this but i have face problem Get record but showing in multiple time entries.
var Result = (
from
THiting
in
_context.TblHittingStatsDetail
join
UM
in
_context.UserMaster
on
THiting.UserId equals UM.UserId
join
TPitching
in
_context.TblPitchingStatsDetails
on
UM.UserId equals TPitching.UserId
where
THiting.UserId ==Id && TPitching.UserId == Id
select
new
{
UM.UserId,
THiting.
Date
,
THiting.GameTime,
THiting.Average,
THiting.Obp,
THiting.Single,
THiting.
Double
,
THiting.Triple,
THiting.Hr,
THiting.Hbp,
THiting.Bb,
THiting.Rbis,
THiting.Runs,
THiting.KSwinging,
THiting.LLooking,
THiting.RightOrLeftyPitcherWhatAtBat,
THiting.Lineout,
THiting.Groundout,
THiting.Popout,
THiting.Temperature
//PitchingDate = TPitching.
Date
,
//PitchingTime = TPitching.GameTime,
//TPitching.Ip,
//TPitching.PitchingStatsId,
//TPitching.Era,
//PitchingRun = TPitching.Runs,
//TPitching.Strikeouts,
//TPitching.Walks,
//PitchingHbp = TPitching.Hbp,
//PitchingLineout = TPitching.Lineout,
//TPitching.Popouts,
//PitchingGroundout = TPitching.Groundout,
//TPitching.FbVelo,
//TPitching.CbVelo,
//TPitching.SlVelo,
//TPitching.ChVelo,
//PitchingTemp = TPitching.Temperature
Reply
Answers (
1
)
how to add current date and time to datacolumn of datatable in asp.net
How to create grpc server application