⚡ Sangsakala Proxy 🏠 Home
Skip to content

Commit d4418da

Browse files
committed
Add Load method to Database class also
1 parent 6d33564 commit d4418da

3 files changed

Lines changed: 66 additions & 1 deletion

File tree

‎DirectSQL/Database.cs‎

Lines changed: 40 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -387,6 +387,46 @@ public static P CreateParameter(string name, object value)
387387
return new P() { ParameterName = name, Value = value };
388388
}
389389

390+
public static dynamic[] LoadSqlResult(
391+
String sql,
392+
(String,object)[] parameters,
393+
C connection,
394+
T transaction)
395+
{
396+
return SqlResult.LoadSqlResult(sql, parameters, connection, transaction);
397+
}
398+
399+
public static dynamic[] LoadSqlResult(
400+
String sql,
401+
C connection,
402+
T transaction)
403+
{
404+
return SqlResult.LoadSqlResult(sql, connection, transaction);
405+
}
406+
407+
public static async Task<dynamic[]> LoadSqlResultAsync(
408+
String sql,
409+
(String, object)[] parameters,
410+
C connection,
411+
T transaction)
412+
{
413+
return await SqlResult.LoadSqlResultAsync(
414+
sql,
415+
parameters,
416+
connection,
417+
transaction);
418+
}
419+
420+
public static async Task<dynamic[]> LoadSqlResultAsync(
421+
String sql,
422+
C connection,
423+
T transaction)
424+
{
425+
return await SqlResult.LoadSqlResultAsync(
426+
sql,
427+
connection,
428+
transaction);
429+
}
390430

391431
public class SqlResult: DirectSQL.SqlResult<R,CMD,T,C,P>
392432
{

‎DirectSQL/doc/articles/intro.md‎

Lines changed: 0 additions & 1 deletion
Original file line numberDiff line numberDiff line change
@@ -32,7 +32,6 @@ public static void example2()
3232
{
3333
dynamic[] resultArray =
3434
SqlLiteDatabase
35-
.SqlResult
3635
.LoadSqlResult(
3736
"select TEST_COL1,TEST_COL2 from TEST_TABLE",
3837
connection,

‎TestSqlLiteDatabase/SqlResultTest.cs‎

Lines changed: 26 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -227,6 +227,18 @@ public void TestLoad()
227227
Assert.AreEqual(result[0].TEST_COL2, 123);
228228
Assert.AreEqual(result.Length, 2);
229229

230+
231+
dynamic[] result2 =
232+
SqlLiteDatabase
233+
.LoadSqlResult(
234+
"select TEST_COL1,TEST_COL2 from TEST_TABLE",
235+
conn,
236+
tran);
237+
238+
Assert.AreEqual(result2[0].TEST_COL1, "testValue");
239+
Assert.AreEqual(result2[0].TEST_COL2, 123);
240+
Assert.AreEqual(result2.Length, 2);
241+
230242
});
231243
}
232244

@@ -255,6 +267,20 @@ public void TestLoadAsync()
255267
Assert.AreEqual(result[0].TEST_COL2, 123);
256268
Assert.AreEqual(result.Length, 2);
257269

270+
dynamic[] result2 =
271+
SqlLiteDatabase
272+
.LoadSqlResultAsync(
273+
"select TEST_COL1,TEST_COL2 from TEST_TABLE",
274+
conn,
275+
tran)
276+
.Result;
277+
278+
Assert.AreEqual(result2[0].TEST_COL1, "testValue");
279+
Assert.AreEqual(result2[0].TEST_COL2, 123);
280+
Assert.AreEqual(result2.Length, 2);
281+
282+
283+
258284
});
259285
}
260286

0 commit comments

Comments
 (0)