linqtemplates

How Can I Get the Identity Column Value Associated with a SubSonic 3 LinqTemplate Insert?

I am using SubSonic 3.0.0.3 along with the Linq T4 Templates. My ProjectRepository, for example, has the following two methods: public int Add(Project item) { int result = 0; ISqlQuery query = BuildInsertQuery(item); if (query != null) { result = query.Execute(); } return result; } private ISqlQuery Bui...

SubSonic 3 Linq projecting anonymous types but not class types

I am fairly new to SubSonic 3/Linq, and don't know if I'm missing something obvious, but I think I ran into a projection issue. I am trying to perform the most basic query, and getting back proper results only when I use anonymous types. The moment I swap the anonymous types with regular class types, I get all properties set to null/zero...