1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
|
/*
* Firebird ADO.NET Data provider for .NET and Mono
*
* The contents of this file are subject to the Initial
* Developer's Public License Version 1.0 (the "License");
* you may not use this file except in compliance with the
* License. You may obtain a copy of the License at
* http://www.firebirdsql.org/index.php?op=doc&id=idpl
*
* Software distributed under the License is distributed on
* an "AS IS" basis, WITHOUT WARRANTY OF ANY KIND, either
* express or implied. See the License for the specific
* language governing rights and limitations under the License.
*
* Copyright (c) 2002, 2004 Carlos Guzman Alvarez
* All Rights Reserved.
*/
using System;
using System.Data;
using FirebirdSql.Data.Firebird;
using NUnit.Framework;
namespace FirebirdSql.Data.Firebird.Tests
{
/// <summary>
/// All the test in this TestFixture are using implicit transaction support.
/// </summary>
[TestFixture]
public class FbStoredProcCallsTest : BaseTest
{
public FbStoredProcCallsTest() : base(false)
{
}
[Test]
public void FirebirdLikeTest00()
{
FbCommand command = new FbCommand("EXECUTE PROCEDURE GETVARCHARFIELD(?)", Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.VarChar).Direction = ParameterDirection.Input;
command.Parameters.Add("@VARCHAR_FIELD", FbDbType.VarChar).Direction = ParameterDirection.Output;
command.Parameters[0].Value = 1;
// This will fill output parameters values
command.ExecuteNonQuery();
// Check the value
Assert.AreEqual("IRow Number 1", command.Parameters[1].Value);
// Dispose command - this will do a transaction commit
command.Dispose();
}
[Test]
public void FirebirdLikeTest01()
{
FbCommand command = new FbCommand("SELECT * FROM GETVARCHARFIELD(?)", Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.VarChar).Direction = ParameterDirection.Input;
command.Parameters[0].Value = 1;
// This will fill output parameters values
FbDataReader reader = command.ExecuteReader();
reader.Read();
// Print output value
Console.WriteLine("Output Parameters - Result of SELECT command");
Console.WriteLine(reader[0]);
reader.Close();
// Dispose command - this will do a transaction commit
command.Dispose();
}
[Test]
public void SqlServerLikeTest00()
{
FbCommand command = new FbCommand("GETVARCHARFIELD", Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.VarChar).Direction = ParameterDirection.Input;
command.Parameters.Add("@VARCHAR_FIELD", FbDbType.VarChar).Direction = ParameterDirection.Output;
command.Parameters[0].Value = 1;
// This will fill output parameters values
command.ExecuteNonQuery();
// Print output value
Console.WriteLine("Output Parameters");
Console.WriteLine(command.Parameters[1].Value);
// Dispose command - this will do a transaction commit
command.Dispose();
}
[Test]
public void SqlServerLikeTest01()
{
FbCommand command = new FbCommand("GETRECORDCOUNT", Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@RECORDCOUNT", FbDbType.Integer).Direction = ParameterDirection.Output;
// This will fill output parameters values
command.ExecuteNonQuery();
// Print output value
Console.WriteLine("Output Parameters - Record Count");
Console.WriteLine(command.Parameters[0].Value);
// Dispose command - this will do a transaction commit
command.Dispose();
}
[Test]
public void SqlServerLikeTest02()
{
FbCommand command = new FbCommand("GETVARCHARFIELD", Connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@ID", FbDbType.VarChar).Value = 1;
// This will fill output parameters values
FbDataReader r = command.ExecuteReader();
int count = 0;
while (r.Read())
{
count++;
}
r.Close();
// Dispose command - this will do a transaction commit
command.Dispose();
Assert.AreEqual(1, count);
}
}
}
|
