public static string[] ListFieldsIntersect(CruiseDatastore db, string table1, string table2) { var sourceFields = db.QueryScalar2 <string>($@"SELECT '""' || Name || '""' FROM pragma_table_info('{table1}');"); var destFields = db.QueryScalar2 <string>($@"SELECT '""' || Name || '""' FROM pragma_table_info('{table2}');"); var both = sourceFields.Intersect(destFields).ToArray(); return(both); }