本文整理汇总了C#中System.Data.Select.BuildSqlStatement方法的典型用法代码示例。如果您正苦于以下问题:C# Select.BuildSqlStatement方法的具体用法?C# Select.BuildSqlStatement怎么用?C# Select.BuildSqlStatement使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类System.Data.Select
的用法示例。
在下文中一共展示了Select.BuildSqlStatement方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Join_Unequal
public void Join_Unequal()
{
SubSonic.SqlQuery q = new Select("productID", "categoryName")
.From(Product.Schema)
.NotEqualJoin(Category.Schema);
string sql = q.BuildSqlStatement();
Assert.AreEqual(
"SELECT [dbo].[Products].[ProductID], categoryName\r\n FROM [dbo].[Products]\r\n JOIN [dbo].[Categories] ON [dbo].[Products].[CategoryID] <> [dbo].[Categories].[CategoryID]\r\n",
sql);
}
示例2: Select_BetweenAnd
public void Select_BetweenAnd()
{
SubSonic.SqlQuery q = new Select("productid").From(Product.Schema).Where("productid").IsBetweenAnd(2, 5);
string sql = q.BuildSqlStatement();
Assert.AreEqual(
"SELECT [dbo].[Products].[ProductID]\r\n FROM [dbo].[Products]\r\n WHERE [dbo].[Products].[ProductID] BETWEEN @ProductID0_start AND @ProductID0_end\r\n",
sql);
}
示例3: Join_RightOuter
public void Join_RightOuter()
{
SubSonic.SqlQuery q = new Select("productID", "categoryName")
.From(Product.Schema)
.RightOuterJoin(Category.Schema);
string sql = q.BuildSqlStatement();
Assert.AreEqual(
"SELECT [dbo].[Products].[ProductID], categoryName\r\n FROM [dbo].[Products]\r\n RIGHT OUTER JOIN [dbo].[Categories] ON [dbo].[Products].[CategoryID] = [dbo].[Categories].[CategoryID]\r\n",
sql);
}
示例4: Aggregate_Count
public void Aggregate_Count()
{
SubSonic.SqlQuery q = new Select(
Aggregate.Count("ProductID"),
Aggregate.Sum("UnitPrice", "boots"),
Aggregate.GroupBy("categoryID"))
.From("Products").Where("CategoryID").IsGreaterThan(5)
.OrderAsc("categoryID").OrderDesc("boots");
string sql = q.BuildSqlStatement();
Assert.AreEqual(
"SELECT COUNT(ProductID) AS 'CountOfProductID', SUM(UnitPrice) AS 'boots', categoryID AS 'GroupByOfcategoryID'\r\n FROM [dbo].[Products]\r\n WHERE [dbo].[Products].[CategoryID] > @CategoryID0\r\n GROUP BY categoryID\r\n ORDER BY categoryID ASC,boots DESC\r\n",
sql);
}
示例5: Join_Cross
public void Join_Cross()
{
SubSonic.SqlQuery q = new Select("productID", "categoryName")
.From(Product.Schema)
.CrossJoin(Category.Schema);
string sql = q.BuildSqlStatement();
Assert.AreEqual(
"SELECT [dbo].[Products].[ProductID], [dbo].[Categories].[CategoryName]\r\n FROM [dbo].[Products]\r\n CROSS JOIN [dbo].[Categories]\r\n",
sql);
}
示例6: Join_Cross
public void Join_Cross()
{
SubSonic.SqlQuery q = new Select("productID", "categoryName")
.From(Product.Schema)
.CrossJoin(Category.Schema);
string sql = q.BuildSqlStatement();
//Assert.Fail("sql = " + sql);
//SELECT `main`.`Products`.`ProductID`, `main`.`Categories`.`CategoryName`
// FROM `main`.`Products`
// CROSS JOIN `main`.`Categories`
Assert.AreEqual(
"SELECT `main`.`Products`.`ProductID`, `main`.`Categories`.`CategoryName`\r\n FROM `main`.`Products`\r\n CROSS JOIN `main`.`Categories`\r\n",
sql);
}