public void TestFormatBody_DontAddDilimiter() { var service = new SqlQueryService(); var result = service.FormatBody("select * from users;"); Assert.AreEqual("select * from users;", result); }
public void CreateEmptyTable() { var service = new SqlQueryService(); var result = DbHelper.TryCreateEmptyTable <User>(service.DefaultPrimaryKeyName); Assert.AreEqual("User", result.TableName); Assert.AreEqual(typeof(User), result.ModelType); Assert.AreEqual(1, result.MappingByColumnName.Count); Assert.AreEqual(1, result.PrimaryKeys.Count()); Assert.AreEqual("Id", result.PrimaryKeys[0].ColumnName); Assert.AreEqual("User", result.PrimaryKeys[0].TableName); Assert.AreEqual(typeof(User), result.PrimaryKeys[0].ModelType); Assert.AreEqual("Id", result.PrimaryKeys[0].PropertyName); Assert.AreEqual(true, result.PrimaryKeys[0].IsDatabaseGenerated); Assert.AreEqual(false, result.PrimaryKeys[0].IsIgnored); }
public SqlQueryService GetService() { var service = new SqlQueryService(); return(service); }