LLBLGEN PRO 2.5 Oracle 10g/ sqlServer2000 Innodb C#.Net 2005 Adapter

Does llblgen support Decode/Case? If it does, what is the syntax?

These are DB functions, right?

Please check the following documentation section:

Generated code - Calling a database function

Thanks for it, it will work if I could generate a dynamic CASE statement for it.

I need to get the Database Table Names of entities, and database column names of Entities' fields. For Example;

I want to generate a Sql like this; CASE [Confida40].[dbo].[SIPARIS_KALEMI].[SATIR_TIPI] WHEN 'M' THEN [Confida40].[dbo].[ITEM].[TANIM] WHEN 'H' THEN [Confida40].[dbo].[SP_HIZMET_KARTI].[TANIMI] END AS [UHTanimi],

but i get the Sql

CASE [Confida40].[dbo].[SIPARIS_KALEMI].[SATIR_TIPI] WHEN 'M' THEN [Tanim] WHEN 'H' THEN [Tanimi] END AS [UHTanimi],

with this code

fields.DefineField(new EntityField2("UHTanimi", 
            new DbFunctionCall(
        "CASE {0} WHEN 'M' THEN [" + ItemFields.Tanim.Name + "] WHEN 'H' THEN  [" 
        + SpHizmetKartiFields.Tanimi.Name + "] END",
         new object[] { SiparisKalemiFields.SatirTipi })), 24);

Please try the following:

fields.DefineField(new EntityField2("UHTanimi", 
                new DbFunctionCall(
            "CASE {0} WHEN 'M' THEN [{1}] WHEN 'H' THEN [{2}] END",
             new object[] { SiparisKalemiFields.SatirTipi, ItemFields.Tanim, SpHizmetKartiFields.Tanimi })), 24); 

Thanks, it works.