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