Subsonic 3.0 uses T4 templates, which makes is very easy to extend. One thing that is missing out of the box though, is the ability to specify only tables to be included. The current download (version 3.0.0.3) has an array (ExcludeTables) for specifying table names that we don’t want to generate a DAL for, but if we want to generate only a few tables on a database that has 10s or even hundreds of tables, this is not very efficient. It’s great that the T4 templates are very easy to extend. Continue reading →
ASP.NET: Changing assembly binding
Recently, I had a problem where I was using a different version of an assembly for my custom app, but it had a dependency on a dll that is referring to another version of that assembly.
To be more particular, I am using Subsonic version 2.2 (http://www.subsonicproject.com/) which is an excellent DAL framework but a pre-built library I am using has a dependency on Subsonic version 2.0.3.
To force a particular version of the assembly, we can use the assembly binding.
Here is a sample:
<runtime>
<assemblyBinding xmlns=”urn:schemas-microsoft-com:asm.v1″>
<dependentAssembly>
<assemblyIdentity name=”SubSonic” publicKeyToken=”eadb47849839a332″ />
<bindingRedirect oldVersion=”2.0.0.0-2.0.4.0″ newVersion=”2.2.0.0″ />
</dependentAssembly>
</assemblyBinding>
</runtime>
SAP B1: Getting information on the Database Schema
For SAP B1 developers, its sometimes difficult to determine which table to select from, specially with so many tables and columns on the DB. It does not help much that the table names can be pretty cryptic as well.
Here are some places to get information: Continue reading →