C# (CSharp) CruiseDAL CruiseDatastore.QueryScalar2 Examples

Example #1

File: Updater_HelperMethods.cs Project: FMSC-Measurements/CruiseDAL

        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);
        }