Database

var brandTask = _context.Brands.Find(b => b.Name == brandName).FirstOrDefaultAsync();

var productsFiltered = _context.Products.Find(b => b.Brand == brandName).ToList();
var categoriesDistinct = productsFiltered.GroupBy(c => c.Category).Select(x => x.FirstOrDefault());

var categoriesSelected = new List<Category>();
var categories = await context.Categories.Find( => true).ToListAsync();

// Use filters here for a more complex search of products
var productFilter = Builders<Product>.Filter.Eq("Brand", brandName);
var productsTask = _context.Products.Find(productFilter).ToListAsync();

await Task.WhenAll(brandTask, productsTask);

return new GetBrandPage { Brand = brandTask.Result, Categories = categoriesSelected, Products = productsTask.Result };

How do i browse to let's say 10 records before the last one? Code below:

Dim con As String =
"User=SYSDBA;PASSWORD=masterkey;Database=/DATABASE/TIME_DBS/TC_SHPIRAG3ST4.gdb;Datasource=192.168.2.78;Port=3050;Dialect=3"
    Dim conexiune As FbConnection = New FbConnection(con)
    Private Sub Timer1_Tick(sender As Object, e As EventArgs) Handles Timer1.Tick
        conexiune.Open()
        Try
            Dim sCmd As FbCommand
            Dim sql As String
            Dim ds As FbDataReader
            sql = "select * from RT_TIME ORDER BY RTTI_COUNTER desc"
            sCmd = New FbCommand()
            sCmd.Connection = conexiune
            sCmd.CommandText = sql
            ds = sCmd.ExecuteReader
            ds.Read()

            TextBox1.Text = ds("RTTI_BIT_POS")
            Label1.Text = ds("RTTI_HOOK_POS")

            ds.Close()
            conexiune.Close()
        Catch ex As FirebirdSql.Data.FirebirdClient.FbException
            MsgBox(ex.ToString, vbCritical, "DB Error")
        End Try

    End Sub

CREATE FUNCTION `fTITIK`(number double(8,2)) RETURNS VARCHAR(255) CHARSET latin1
DETERMINISTIC 
BEGIN DECLARE hasil VARCHAR(255); 
SET hasil = REPLACE(REPLACE(REPLACE(FORMAT(number, 2), '.', '|'), ',', '.'), '|', ','); RETURN (hasil); 
END

(
    from ite in this.ItemTransactions
    where ite.DataSourceId == 3
    orderby ite.ItemTransactionId descending
    select new { ite.PrimaryIdInDataSource }
).FirstOrDefault()

-- Region Parameters
DECLARE @p0 Int = 3
-- EndRegion
SELECT TOP (1) [t0].[PrimaryIdInDataSource]
FROM [ItemTransaction] AS [t0]
WHERE [t0].[DataSourceId] = @p0
ORDER BY [t0].[ItemTransactionId] DESC