SqlKata query returns 2 sets of columns

65 Views Asked by At

Using this query ...

Dim compiler = New SqlServerCompiler()
Dim db = New QueryFactory(conn, compiler)

Dim  objFind = db.Query(table) _
        .WhereContains(field1, term1) _
        .OrderByDesc("Start_Date") _
        .Select("sid", "Start_Date", "Subject", "Comment", "isDeleted") _
         .Get()

Returns same columns twice, but correct number of rows to my datagrid. Called by a button click on a windows form with just the button and the datagrid. Data is correct, just the double columns.

On VS2022, latest SqlKata (at net2 standard)

Thoughts?

I tried this as well

Dim objAll = db.Query(table).Get()

it also return double columns

Using SQL Express

0

There are 0 best solutions below