public void To_String_Typed_Alias_With_Alias_Name()
{
IAlias <Person2> person = sql.Alias <Person2>("per");
IFrom from = sql.From(person);
Assert.Equal("FROM Person2 AS per", from.ToString());
}
public void To_String_With_Alias_Name()
{
IAlias person = sql.Alias("dbo.person", "per");
IFrom from = sql.From(person);
Assert.Equal("FROM dbo.person AS per", from.ToString());
}
public void To_String()
{
IAlias person = sql.Alias("dbo.person");
IFrom from = sql.From(person);
Assert.Equal("FROM dbo.person", from.ToString());
}
public void To_String_Subquery()
{
IAlias person = sql.Alias("person");
IFrom from = sql.From(sql.RawQuery("Subquery"), person);
Assert.Equal("FROM (Subquery) AS person", from.ToString());
}
public void To_String_Options()
{
IAlias person = sql.Alias("person");
IFrom from = sql.From(person).Options(sql.Raw("WITH (NO LOCK)"));
Assert.Equal("FROM person WITH (NO LOCK)", from.ToString());
}
public void To_String_Typed_Alias()
{
IAlias <Person> person = sql.Alias <Person>();
IFrom from = sql.From(person);
Assert.Equal("FROM Person AS person", from.ToString());
}