views:

30

answers:

0

When I try to do something along the lines of

var myTableAll = myTable.All(connectionString, "System.Data.SqlClient");
var count = myTableAll.Count();   // this works

foreach( var record in myTableAll ) { DoSomething(record); }  // this throws an exception

the excpetion is thrown because it is looking for the database connection string in the config file.

I would really like to use the linq with SubSonic and the All() method but I'm not sure if that is possible if the connection string isn't kept.