public async Task TableSchema(DbClient client) { TableSchema schema = await client.GetTableSchema("people"); Assert.IsFalse(schema == null); Assert.AreEqual(3, schema.Count()); TableField id = schema["id"]; Assert.IsFalse(id == null); Assert.AreEqual("id", id.Name); if (!(client is SqlServer.SqlServerClient)) { Assert.AreEqual(KeyType.Primary, id.Key); } if (!(client is Sqlite.SqliteClient) && !(client is SqlServer.SqlServerClient)) { Assert.AreEqual(true, id.AutoIncrement); Assert.AreEqual(true, id.NotNull); } TableField name = schema["name"]; Assert.IsFalse(name == null); Assert.AreEqual(typeof(string), name.Type); TableField bd = schema["birthday"]; Assert.IsFalse(bd == null); Assert.AreEqual(typeof(DateTime), bd.Type); client.Dispose(); }