This repository aims to provide a well-documented example of using Entity Framework 6 and LinQ for use in custom user controls for the Climsoft project developed in VisualBasic.NET
Initial tasks
- Develop examples simultaneously for a station selector and an element selector (connecting to db.stations and db.obselement)
Ability to perform following filters:
- equals "67774010"
- IN {"67774010", "67775050"}
- date greater #01/01/2001#
In addition, the ability to provide a extra customised columns from the select (e.g. the concatenation of id and name)
Further tasks
- Switch to stationelement. Only return those stations that can have data for the currently selected element(s), or only those elements available at the currently selected station(s)
NOTES:
-
Array vs List
-
IQueryable vs IEnumerable, including notes on paging with Take and Skip (see also diagram). Testing that an object implements an interface doesn't guarented that extension methods will be available.
-
DataSource vs BindingSource
-
Interfaces (vs Duck Typing and ABCs)
-
"Unable to convert MySQL date/time value to System.DateTime"
-
Replace
Chr(34) &string concatenation with escaped quotes ("""), StringBuilder and String.Format. Also check whether using + or & for concatenation.