Knight Data Access Layer contains built in LINQ providers for SQL Server, MS Access, Oracle, Firebird, VistaDB, Sqlite, and MySQL. It supports all standard LINQ select expressions including:

• Where
• Join
• Skip
• Take
• Any
• Union
• Aggregate
• GroupBy
• First
• FirstOrDefault
• OrderBy
• OrderByDescending
• All
• Contains
• Between
• Average
• Sum
• Max
• Min
• Coalesce
• Count
• String Expressions (Example: StartsWith)
• Date Expressions (Example: Minute)
• Math Expressions (Example: Ceiling)

 

'Create a new Person to save to the database

Dim person As Person = New Person With {.FirstName = "Greg", .LastName = "Smith", .DateCreated = Date.Now.Date}

　

'Get the current instance of the helper

Dim db As IDataHelper = DataHelper.SessionFactory()

　

'Save it

db.Save(person)

　

Dim query = db.CreateQuery(Of Person)()

Dim persons = query.Where(Function(o) o.FirstName = "Greg")