Using sqlcn As SQLiteConnection = New SQLiteConnection(String.Format(CONNECTION_STRING_TEMPLATE, dbFilePath))
Using sqlcnOff As SQLiteConnection = New SQLiteConnection(String.Format(Common.CONNECTION_STRING_TEMPLATE, Common.GetDBPathOffline()))
Try
sqlcn.Open()
sqlcnOff.Open()
Dim SchemaTable = sqlcn.GetSchema(SQLiteMetaDataCollectionNames.Tables)
Dim SchemaTableOffline = sqlcnOff.GetSchema(SQLiteMetaDataCollectionNames.Tables)
Dim matchingTables = From s1 In SchemaTable.AsEnumerable().ToList() _
Join s2 In SchemaTableOffline.AsEnumerable().ToList() On s1.Table.TableName Equals s2.Table.TableName
If matchingTables.Count() <> SchemaTable.Rows.Count Or matchingTables.Count() <> SchemaTableOffline.Rows.Count Then
result = DBTESTSRESULTS.DB_FILE_SCHEMA_MISMATCH
Return False
End If
SchemaTable.Rows.Count дает 5, SchemaTableOffline.Rows.Count тоже дает 5. Но почему matchingTables.Count() в результате 25?