通过EFCore调用GBase8s使用skip等选项

前置阅读文章
《EFCore使用ADO.NET连接GBase8s数据库示例》
《C#连接GBase8s数据库在windows环境下使用步骤》
创建解决方案Demo工程，并引入相应的EFCore包

我们本次使用sysmaster数据库。
Select am_id from sysams;
原始查询语句，查询出来的结果

代码参考
try
{
cmd.CommandText = “select am_id from sysams;”;
cmd.ExecuteNonQuery();
GbsDataReader dr = (GbsDataReader)cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
Console.WriteLine(dr[i]);
}
}
}
catch
{
throw;
}

1使用SKIP关键字
select skip 1 am_id from sysams;

执行结果

代码参考
try
{
cmd.CommandText = “select skip 1 am_id from sysams;”;
cmd.ExecuteNonQuery();
GbsDataReader dr = (GbsDataReader)cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
Console.WriteLine(dr[i]);
}
}
}
catch
{
throw;
}

2使用first关键字
select first 1 am_id from sysams;

执行结果

代码参考
try
{
cmd.CommandText = “select first 1 am_id from sysams;”;
cmd.ExecuteNonQuery();
GbsDataReader dr = (GbsDataReader)cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
Console.WriteLine(dr[i]);
}
}
}
catch
{
throw;
}
3 skip和first混用
select skip 1 first 1 am_id from sysams

执行结果

代码参考
try
{
cmd.CommandText = “select skip 1 first 1 am_id from sysams”;
cmd.ExecuteNonQuery();
GbsDataReader dr = (GbsDataReader)cmd.ExecuteReader();
while (dr.Read())
{
for (int i = 0; i < dr.FieldCount; i++)
{
Console.WriteLine(dr[i]);
}
}
}
catch
{
throw;
}