Hi Kim,

you can find the text templates that are used to generate the tables.sql and storedprocedures.sql files in the TextTemplates directory under the CslaFactory installation directory. The templates dealing with database files all start with a DB-prefix. For example, DBTables.tt, DBStoredProcedureList.tt and so on. There is currently no proper documentation, so I think it might be a good idea to blog about it or open a thread so we can discuss some aspects of customizing the CslaFactory.

With the current release (CTP) it is not possible to map C# types to DB types other than SQL Server, because the provider model wasn't finished on time. Our current development version already uses the provider model to map types during the generation process.
If you want to change the mapping (for using a different database or even using non-standard types in your model), you need to implement a specific interface (IPropertyConversionProvider). There is a GetDatabaseType(PropertyType propertyType)-method, for example, that returns the string representation for the database type of given BusinessObject's property. Having implemented this interface, you will be able to introduce your conversion provider-.dll by extending a configuration file. The generation host will discover it and use your provider on generation.

-Marcel