If you had one SubSonic desire, what would it be?

Question

I know this question seems subjective, but it is really quite simple. As a long-term SubSonic user and contributor , I'm interested in what the community considers the best way to Improve this. So, what is your opinion, how would you make SubSonic even better? What one can make you more likely to use / recommend / evangelise / stop complain about it?

As I said, I know that this is a little subjective and may close, but since SO is the main SubSonic support forum, I think this may be a useful way to request an opinion and / or input.

So that this does not turn into a general discussion here, the rules:

• No regards omnibus
• No duplicate wishes
• Voting skills you agree with, not re-posting them.

Answer 1

Ability to run in MediumTrust out of the box

Answer 2

In all honesty, the biggest thing that is missing is reliable documentation and HowTo

He got better, but I think he needs a lot more.

Answer 3

The ability to automatically match collections of other objects, such as Fluent NHibernate.

Answer 4

When SubSonic throws an exception that is not clear, I would like to be able to use Google or some other mechanism to learn more about how to keep moving forward. It is now too easy to get into a situation where you need to switch to the SubSonic source code, because SubSonic does not seem very active when the user disables the “happy journey”.

This criticism is hardly specific to SubSonic. Because of this problem, many (most?) Software products arise. I actually did not have this problem with NHibernate, although this is the most understandable competitor to SubSonic.

Answer 5

Faster and better releases

Answer 6

Binary Types for SimpleRepository (Images)

Answer 7

Left outer join

Answer 8

Support for more database independent code generation ...

I mean, this is really a real pain if your application wants to talk to different databases (for example, SQL Server and Oracle), and you want to have only one set of generated DAL objects. I would really like it if you had the opportunity to indicate that any SQL code that is sent to the database will be as compatible with most engines as possible right now, if you generated objects aimed at SQL Server, then all queries will have form

SELECT [schema]. [table_name] FROM ....

Unfortunately, this does not work in Oracle, so basically you are out of luck there.

Perhaps this is a big problem for most of you, but I'm currently writing a commercial application that advertises one of its main functions as the ability to run databases on different machines, just changing its configuration, and I chose SubSonic because I thought that he can handle this task quite easily, but to be honest, the second time I think that because of all the hoops, I may have to slip through to get this to work correctly under different conditions.

Answer 9

Support for MS Access, Postgres and FireBird database :)