I have a table in the database. User cannot change values there, they are kind of hard coded.
I want this table to populate <select> list, I know how to do it on the page where <select> list is placed.
The thing is I would like to populate variable:
var myQuery = db.Query("SELECT * FROM tyoes");
and make this variable visible for many pages to use it to populate many <select> lists on many pages.
How can I do it?
Also: do I have to initialize database on every page I use it?
var db = Database.Open("StarterSite");