I have an application that requires we use distinct user connection strings per user. We are trying to upgrade from SubSonic 2.x to 3.0. I'm running into issues with trying to create a List<> of objects. When I try to create a List like this:
List<table_name> oList = table_name.All().Where(tn => tn.table_id == TableId).ToList();
I get the error "Connection string 'ConnectionStringName' does not exist."
So, I try to create the List<> like this:
List<table_name> oList = table_name.All(sConnectionString, "System.Data.SqlClient").Where(tn => tn.table_id == TableId).ToList();
I get the error "The name 'table_name' does not exist in the current context."
I'm using SQL Server, and the sConnectionString is definitely verified to be a good connection string, and the table_name is a table in the database. What am I doing wrong?