C# (CSharp) SqlCeEngine.GetSchemaInformationViews示例

示例#1

        public void AnalyzeDatabase()
        {
            using (var engine = new SqlCeEngine(ConnectionString))
            {
                var schema = engine.GetSchemaInformationViews();

                var tables = schema.Tables["INFORMATION_SCHEMA.TABLES"].AsEnumerable().Select(c => c.Field <string>("TABLE_NAME")).ToList();
                if (tables.Count == 0)
                {
                    return;
                }

                var tableList = GetTableInformation(tables, schema);
                Tables.AddRange(tableList.Values);

                FetchPrimaryKeys(schema);
                FetchIndexes(schema);
            }
        }