Exemplos de MySqlSchemaProvider em C# (CSharp)

Exemplo n.º 1

        public void TestGetForeignKeyColumns()
        {
            MySqlSchemaProvider provider = new MySqlSchemaProvider();

            provider.ConnectionString = connectionString;

            var table = provider.GetForeignKeyColumns("examples", string.Empty, "tb_News");
        }

Exemplo n.º 2

Arquivo: MySqlSchemaProviderTests.cs Projeto: spottedmahn/IQToolkitContrib

        private ISchemaProvider GetProvider()
        {
            var provider = new MySqlSchemaProvider();

            provider.SetConnectionString("Host=127.0.0.1;UserName=test;Password=test;Database=Northwind");

            return(provider);
        }

Exemplo n.º 3

        public void TestGetTable()
        {
            MySqlSchemaProvider provider = new MySqlSchemaProvider();

            provider.ConnectionString = connectionString;

            var table = provider.GetTable("examples", string.Empty, "tb_News");

            Assert.AreEqual("Id", table.Columns[0].Name);
            Assert.AreEqual(DbType.String, table.Columns[0].Type);
        }