public void ObjectReference_With_Incorrect_Input() { // Arrange String expectedResult = ""; DataRow row = (new DataTable()).NewRow(); // Act KeyValuePair <String, String> result = SQLProviderHelper.CreateObjectReference(row); // Assert Assert.Equal(expectedResult, result.Value); Assert.Equal("", result.Key); }
public void ObjectReference_With_1_Component() { // Arrange String expectedResult = "Table"; DataRow row = CreateDataRow(); row["TABLE_NAME"] = "Table"; // Act KeyValuePair <String, String> result = SQLProviderHelper.CreateObjectReference(row); // Assert Assert.Equal(expectedResult, result.Value); Assert.Equal(row["TABLE_NAME"], result.Key); }
public void ObjectReference_With_All_3_Components() { // Arrange String expectedResult = "Database.Schema.Table"; DataRow row = CreateDataRow(); row["TABLE_CATALOG"] = "Database"; row["TABLE_SCHEMA"] = "Schema"; row["TABLE_NAME"] = "Table"; // Act KeyValuePair <String, String> result = SQLProviderHelper.CreateObjectReference(row); // Assert Assert.Equal(expectedResult, result.Value); Assert.Equal(row["TABLE_NAME"], result.Key); }
/// <summary> /// List the tables and views in the SQL Connection /// </summary> /// <returns>The list of tables and views in the SQL Connection</returns> public override List <KeyValuePair <String, String> > ObjectList() { // Set up the result List <KeyValuePair <String, String> > result = new List <KeyValuePair <String, String> >() { }; // Is the data provider connected? If not don't attempt to read the schema if (this.Connected) { // Get the raw tables list DataTable rawTables = this.sqlConnection.GetSchema("Tables"); foreach (DataRow row in rawTables.Rows) { result.Add(SQLProviderHelper.CreateObjectReference(row)); } } // Send the result back to the caller return(result); }