public void ToString_WithAlias_GeneratesCorrectSQLClause() { Tables_Blogs table = new Tables_Blogs().As("MyTable"); var from = new FromClause(table); string expected = @"FROM [dbo].[Blogs] AS [MyTable] "; Assert.AreEqual(expected, from.ToString()); }
public void ToString_Always_GeneratesCorrectSQLClause() { var table = new Tables_Blogs(); var from = new FromClause(table); string expected = @"FROM [dbo].[Blogs] "; Assert.AreEqual(expected, from.ToString()); }
public void ToString_WithJoin_GeneratesCorrectSQLClause() { var blogs = new Tables_Blogs(); var posts = new Tables_Posts(); FromClause from = new FromClause(blogs).Join(posts, blogs.Id == posts.BlogId); string expected = @"FROM [dbo].[Blogs] JOIN [dbo].[Posts] ON ([dbo].[Blogs].[Id] = [dbo].[Posts].[BlogId]) "; Assert.AreEqual(expected, from.ToString()); }
public void ToString_WithMoreThanOneField_GeneratesCorrectSQLClause() { var table = new Tables_Blogs(); var fields = new IFormatableField[] { new Tables_Blogs_Id(table), new Tables_Blogs_Name(table) }; var select = new SelectClause(fields); string expected = @"SELECT [dbo].[Blogs].[Id], [dbo].[Blogs].[Name] "; Assert.AreEqual(expected, select.ToString()); }