C# (CSharp) MetaRepository.GetStoredProcedureInfo Beispiele

Beispiel #1

Datei: MetaRepositoryTests.cs Projekt: TheDev6/SqlMeta

        public void TestMetaRespository()
        {
            string connectionString = @"";

            var repo = new MetaRepository(connectionString: connectionString);

            var tables = repo.GetTableInfo();

            var sprocs = repo.GetStoredProcedureInfo().Where(s=>!s.Name.Contains("diagram"));

            dynamic display = new ExpandoObject();
            display.Tables = tables;
            display.Sprocs = sprocs;

            var jsonString = JsonConvert.SerializeObject(display, Formatting.Indented);

            File.WriteAllText("Shabang.txt", jsonString);
        }

Beispiel #2

        public void TestMetaRespository()
        {
            string connectionString = @"";

            var repo = new MetaRepository(connectionString: connectionString);

            var tables = repo.GetTableInfo();

            var sprocs = repo.GetStoredProcedureInfo().Where(s => !s.Name.Contains("diagram"));

            dynamic display = new ExpandoObject();

            display.Tables = tables;
            display.Sprocs = sprocs;

            var jsonString = JsonConvert.SerializeObject(display, Formatting.Indented);

            File.WriteAllText("Shabang.txt", jsonString);
        }