Join

Question

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?

Satyapriya Nayak · Answer

Hi Aaron Please refer the below link http://www.1keydata.com/sql/sqljoins.html http://www.1keydata.com/sql/sqlunion.html Thanks

Mukesh Kumar · Answer

http://www.mssqltips.com/sqlservertip/1667/sql-server-join-example/ http://www.tizag.com/sqlTutorial/sqlunion.php

Jignesh Trivedi · Answer

Hi 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.