本文整理汇总了C#中SQLiteConnection.CreateFunction方法的典型用法代码示例。如果您正苦于以下问题：C# SQLiteConnection.CreateFunction方法的具体用法？C# SQLiteConnection.CreateFunction怎么用？C# SQLiteConnection.CreateFunction使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类SQLiteConnection的用法示例。
在下文中一共展示了SQLiteConnection.CreateFunction方法的1个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: TestFunctionStatic
public void TestFunctionStatic()
{
using (var connection = new SQLiteConnection(this.databaseRelativePath))
{
connection.CreateFunction(
"CUSTOMFUNCSUMSTATIC",
2,
GeneralUnitTest.StaticFunction,
true);
using (var statement = connection.Prepare("DROP TABLE IF EXISTS TestFunctionStatic;"))
{
statement.Step();
}
using (var statement = connection.Prepare("CREATE TABLE TestFunctionStatic(id INTEGER, a INTEGER, b INTEGER);"))
{
statement.Step();
}
using (var statement = connection.Prepare("INSERT INTO TestFunctionStatic(id, a, b) VALUES(@id, @a, @b);"))
{
for (var value = 0; value < 10; value++)
{
statement.Bind(1, value);
statement.Bind("@a", value - 1);
statement.Bind("@b", value + 1);
statement.Step();
statement.Reset();
statement.ClearBindings();
}
}
using (var statement = connection.Prepare("SELECT id, CUSTOMFUNCSUMSTATIC(a, b) / 2 AS CustomResult FROM TestFunctionStatic ORDER BY id ASC;"))
{
while (statement.Step() == SQLiteResult.ROW)
{
var id = (long)statement[0];
var customResult = (long)statement[1];
Assert.AreEqual(id, customResult);
}
}
using (var statement = connection.Prepare("DROP TABLE TestFunctionStatic;"))
{
statement.Step();
}
}
}