extracting values to be populated in a dropdown from SQLite database <p>I am developing a web application using ASP.NET MVC and using FluentNHibernate for ORM. I am faced with a situation.</p> <p>I have 8 tables say A,B,C,D,E,F,G,H and each table has say 10 attributes, out of which an average of 5 are lists that have to be populated as dropdowns in the view.</p> <p>Now, these values have to be extracted from the database. I have built individual tables for each dropdown attribute in table A with values, say HighestEducation is an attribute in A and the dropdown values include Undergrad, Masters, Doctorate, etc.</p> <p>I want to build a tightly coupled ADO.NET entity model for that table, but cant seem to do so. Any suggestions on how to get around this one? </p>