Hi.........
I am working in ADO.NET and face a problem in Join. How can we define Join and union with Syntax.How many types of Join are used in ADO.NET?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Jan 9, 2012, 1:17 PM
Please refer the below link
http://www.1keydata.com/sql/sqljoins.html
http://www.1keydata.com/sql/sqlunion.html
Thanks
Mukesh KumarPosted Jan 10, 2012, 11:47 PM
http://www.tizag.com/sqlTutorial/sqlunion.php
Jignesh TrivediPosted Jan 10, 2012, 11:30 PM
Are you using ADO.net or Entity Framework?
if ADO.net then..
There is no join in ADO.net but it depend on data relation.
following link may help u .
http://msdn.microsoft.com/en-us/magazine/cc188919.aspx
and EF and Linq support join
http://msdn.microsoft.com/en-us/library/aa697427%28v=vs.80%29.aspx
hope this help.