BUG: The FillSchema method may not include schema for the PrimaryKey column for the join query (817183)

MORE INFORMATION

Steps to reproduce the behavior

1. In Microsoft Visual Studio .NET, create a new Console Application by using Visual Basic .NET or Visual C# .NET.
2. Replace the existing code with the following code:

   Visual Basic .NET code

   Imports System
   Imports System.Data
   Imports System.Data.SqlClient
   Imports System.Data.OleDb
   
   Module Module1
   
      Sub Main()
         'connect to SQlserver
         Dim cn As New SqlClient.SqlConnection()
         Dim strConn As String = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=(local)"
         cn.ConnectionString = strConn
         Dim strSQL As String = "SELECT O.OrderID,  O.EmployeeID FROM Orders O, Customers C WHERE O.CustomerID = C.CustomerID AND C.Country = 'Mexico'"
   
         'use a SqlDataAdapter 
         Dim daSql As New SqlClient.SqlDataAdapter(strSQL, cn)
         Dim tbl As New DataTable()
   
         'configure tbl to match with schema of the source
         daSql.FillSchema(tbl, SchemaType.Source)
   
         'display the Primary Key columnname of the table
         If Not (tbl.PrimaryKey.Length = 0) Then
            Console.WriteLine("PrimaryKey from SqlClient: " & tbl.PrimaryKey(0).ColumnName)
         Else
            Console.WriteLine("No PRIMARY KEY For the table ")
         End If
   
         'use a OleDbDataAdapter with SQLOLEDB provider
         Dim daOleDb As New OleDb.OleDbDataAdapter(strSQL, "Provider=SQLOLEDB;" & strConn)
         tbl.Reset()
   
         'configure tbl to match with schema of the source
         daOleDb.FillSchema(tbl, SchemaType.Source)
         Console.WriteLine("PrimaryKey from OleDb: " & tbl.PrimaryKey(0).ColumnName)
         Console.ReadLine()
      End Sub
   
   End Module
   

   Visual C# .NET code

   using System;
   using System.Data;
   using System.Data.SqlClient;
   using System.Data.OleDb;
   class Class1
   {		 	  
   [STAThread]
   static void Main(string[] args)
   	{
   	//connect to your local SQLServer
   	string strConn = "Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=(local)";
   	SqlConnection cn= new SqlConnection(strConn);
   	string strSQL  = "SELECT O.OrderID, O.EmployeeID FROM Orders O, Customers C WHERE O.CustomerID = C.CustomerID AND C.Country = 'Mexico'";
   
   	//use SqlDataAdapter
   	SqlDataAdapter da = new SqlDataAdapter(strSQL, cn);
   	DataTable tbl= new DataTable();
   
   	//configure tbl to match with schema source
   	da.FillSchema(tbl,SchemaType.Source);
   
   	//display the column name of Primary Key
   	if(tbl.PrimaryKey.Length!=0)	
   			Console.WriteLine("PrimaryKey from SqlClient: " + tbl.PrimaryKey[0].ColumnName );
   		else
   			Console.WriteLine("No Primary Key for the table");
   	
   	//use OleDbDataAdapter
   	OleDbDataAdapter daOleDb = new OleDbDataAdapter(strSQL, "Provider=SQLOLEDB;" + strConn);
   	tbl.Reset();
   	
   	//Configure tbl to match with the schema of source
   	daOleDb.FillSchema(tbl, SchemaType.Source);
   	Console.WriteLine("PrimaryKey from OleDb: " + tbl.PrimaryKey[0].ColumnName);
   	Console.ReadLine();
   	}
   }  
   
   

3. Replace (local) with the name of your SQL Server.
4. On the Debug menu, click Start to run the application.