There is a new file CodeFluent.Runtime.Silverlight4.dll shipped with CodeFluent, that should be used for Silverlight 4 projects.

This is occurring only with generated stored procedures for Oracle Database.

This is a sample importer definition file for a model named EA.Sample.eap. The connection string needs to attributes:

1) Data Source: the .eap file path (may be relative).
2) Package Name: the UML package name to be imported. A .EAP files contains a lot of UML packages. The available package names can be determined using EA's 'Class diagrams' node in the project browser, or using CodeFluent Meta Model Explorer, the Tools / Database Generic Explorer menu.

<?xml version="1.0" encoding="utf-8"?>
<EnterpriseArchitectImporter xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Verbosity>0</Verbosity>
  <Project>
 <DefaultNamespace>EA.Sample</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute>
  <Name>MustCreateDefaultApplication</Name>
  <Value>false</Value>
   </Attribute>
   <Attribute>
  <Name>MustCreateDefaultHints</Name>
  <Value>false</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultMaxLength</Name>
  <Value>64</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultTrackingModes</Name>
  <Value>None</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultConcurrencyMode</Name>
  <Value>None</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultPersistenceUnicode</Name>
  <Value>true</Value>
   </Attribute>
 </Attributes>
  </Project>
  <Entity>
 <Attributes>
   <Attribute>
  <Name>ConcurrencyMode</Name>
  <Value>None</Value>
   </Attribute>
   <Attribute>
  <Name>TrackingModes</Name>
  <Value>None</Value>
   </Attribute>
 </Attributes>
  </Entity>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>Data Source=c:\temp\EA.Sample.Eap;Package Name=Abstract Class Model (PIM)</ConnectionString>
</EnterpriseArchitectImporter>

This producer runs a series of text-based patches on files or directories. Example:
  <cf:producer typeName="CodeFluent.Producers.CodeDom.SearchAndReplaceProducer, CodeFluent.Producers.CodeDom">
    <cf:configuration>
        <patch path="Persistence" fileSearchPattern="*.sql" pattern="ID(?<name>.*)" replace="name=newName" />
        <patch path="Model" fileSearchPattern="*.cs" pattern="blablahh(?<id>[a-z]*)blablah(?<id2>[0-9]*)" replace="id1=whatever;id2=whatever2" />
    </cf:configuration>
  </cf:producer>

'path' can be a directory path or a file path. If relative, it is based from the directory containing the project root part.
'pattern' is a regular expression defining matching groups (see regex documentation for matching groups syntax).
'replace' is a comma separated list of key=value pairs, with a group name as the key, and the replacement string as the value.
'fileSearchPattern' is a file filter expression. Only used if 'path' is a directory.

Note: some CodeFluent features are supported only with the 32 bits version, due to platform limitations: Access & Jet 4.0 importer, OLEDB importer

Example:
  <Address>
    <Id />
    <Line />
    <Geolocation typeName="Geolocation" />
    <cf:instance><Id>1</Id><Line>Somewhere</Line><Geolocation><Latitude>12.1234</Latitude><Longitude>4.222</Longitude></Geolocation></cf:instance>
  </Address>

  <Geolocation lightWeight="true">
    <Latitude typeName="float" />
    <Longitude typeName="float" />
  </Geolocation>

It is also supported by the SharePoint WebParts producer.

Each entity is assigned by default an instance sort order based on its alphabetical order. The 'instancesSortOrder' attribute can be specified on the entity XmlElement to override this order. Example:

 <EmployeeJob instancesSortOrder="-1">
  <Id />
  <Label />
  <cf:instance sortOrder="1"><Id>1</Id><Label>Director</Label></cf:instance>
 </EmployeeJob>

 <Employee>
  <Id />
  <Name />
  <cf:instance sortOrder="2"><Id>1</Id><Name>John Coppola</Name></cf:instance>
  <cf:instance sortOrder="1"><Id>2</Id><Name>Steven Spielberg</Name></cf:instance>
 </Employee>

In this example, EmployeeJob instances will be produced first. This can be useful for example when referential integrity is enforced on the persistence layer.

This is a breaking change if database was accessed using other methods than the CodeFluent provided ones.

Supports both Oracle's Oracle.DataAccess.Client (ODP.Net) and Microsoft's System.Data.OracleClient (standard .NET).

.config file example for .NET oracle provider:
<Oracle.HR connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYORACLESERVER)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));user id=HR;password=hr" persistenceTypeName="System.Data.OracleClient.OracleConnection, System.Data.OracleClient"/>

.config file example for ODP.NET oracle provider:
<Oracle.HR connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=MYORACLESERVER)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));user id=HR;password=hr" persistenceTypeName="Oracle.DataAccess.Client.OracleConnection, Oracle.DataAccess.Client"/>

This is typically used for project where defaultNullableProperty is set to 'false' (the default value is 'true'). Instances for blob properties with external file now automatically use the file properties to define metadata values.

A project targeting Silverlight 3 must use the new assembly CodeFluent.Runtime.Silverlight3.dll. Projects targeting Silverlight 2 must continue to use CodeFluent.Runtime.Silverlight.dll

In this example, we redefine the base grid part for the whole project. The MyEntityGridPart needs to derive from the CodeFluent EntityGridPart.

  <cf:producer name="WSS" typeName="CodeFluent.Producers.SharePoint.WebPartsProducer, CodeFluent.Producers.SharePoint">
  <cf:configuration targetDirectory="mydir" ... >
     <baseClass typeName="CodeFluent.Runtime.SharePoint.WebControls.EntityGridPart" baseTypeName="{1}.MyEntityGridPart" />
  </cf:configuration>
  </cf:producer>

{0} represents the default namespace
{1} represents the project webparts namespace

This allows for example to use an integrated security connection string.

The following example will create [Path]\[Entity].g.cs files for C# projects:

<cf:producer name="Model" typeName="CodeFluent.Producers.CodeDom.CodeDomProducer, CodeFluent.Producers.CodeDom">
    <cf:configuration 
                productionTargetPathFormat="{0}\{1}.g{2}"
                outputName="{0}.dll"
                generateDocumentation="true"
                targetDirectory="%CF_BUILD_NUMBER%\Model" />
    </cf:configuration>
  </cf:producer>

{0} is the target directory
{1} is the file name without extension
{2} is the file extension (".cs" for C# files)

Exemple:
  <Company>
    <Id />
    <Name />
    <SiteUrl typeName="url">
      <cf:rule typeName="UrlValidate" validPorts="80,443" validSchemes="http,https" />
    </SiteUrl>
    <Email typeName="email">
      <cf:rule typeName="EmailValidate" validDomains="*.com,*.fr" />
    </Email>
  </Company>

Set the 'siteCreatorUsesCategoryPath' attribute to true in the producer configuration. The default is false.

The expression between $ and $ must contains the full name of the enumeration value. Example: 

  <Order>
    <Id />
    <Status typeName="Test.Status" />
    <cf:method name="DeleteSomeInvalidOrders" body="raw()">DELETE TOP (2.5) PERCENT FROM $Order$ WHERE $Status$ = $Test.Status.Invalid$" />
  <Order>
  
  <StatusEnum namespace="Test">
    <Unknown />
    <Valid />
    <Invalid />
  </StatusEnum>

To declare a specific 'constraintShortName' on primary keys of derived entities, you need to redeclare the derived property corresponding to the primary key. Example:

<Convoy baseTypeName="Truck">
   <Id constraintShortName="ConvoyPK" />
   <TrucksCount />
 </Convoy>
<Truck baseTypeName="Vehicule">
   <Id constraintShortName="TruckPK" />
   <Capacity />
 </Truck>
<Vehicle>
 <Id constraintShortName="VehiclePK" />
 <WheelsCount />
</Vehicle>

By default, OLE Object columns are imported as byte[]. You need to specify custom ColumnTypeMappers to force the mapping to a CodeFluent blob type. Example with the NorthWinds database:
<AccessImporter>
  <Project><DefaultNamespace>Northwinds</DefaultNamespace><SaveOptions>Free</SaveOptions>
    <Attributes>
      <Attribute><Name>MustCreateDefaultApplication</Name><Value>false</Value></Attribute>
      <Attribute><Name>MustCreateDefaultHints</Name><Value>false</Value></Attribute>
      <Attribute><Name>DefaultMaxLength</Name><Value>64</Value></Attribute>
      <Attribute><Name>DefaultTrackingModes</Name><Value>None</Value></Attribute>
      <Attribute><Name>DefaultConcurrencyMode</Name><Value>None</Value></Attribute>
      <Attribute><Name>DefaultPersistenceUnicode</Name><Value>true</Value></Attribute>
    </Attributes>
  </Project>
  <Entity>
    <Attributes>
      <Attribute><Name>ConcurrencyMode</Name><Value>None</Value></Attribute>
      <Attribute><Name>TrackingModes</Name><Value>None</Value></Attribute>
    </Attributes>
  </Entity>
  <ColumnTypeMappers>
    <ColumnTypeMapper> <!-- don't specify TableName so it can work for all tables -->
      <ColumnName>Picture</ColumnName>
      <TypeName>Picture</TypeName>
    </ColumnTypeMapper>
    <ColumnTypeMapper> <!-- don't specify TableName so it can work for all tables -->
      <ColumnName>Photo</ColumnName>
      <TypeName>Picture</TypeName>
    </ColumnTypeMapper>
  </ColumnTypeMappers>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>99999</MaxEntities>
  <MaxInstances>20</MaxInstances>
  <InstanceImportOptions>
    <!-- Blobs instances with size below this value are inlined in the Xml instances part; otherwise they are imported as external files. The default value is 1024 -->
    <InlineBlobInstanceMaxSize>20000</InlineBlobInstanceMaxSize>
  </InstanceImportOptions>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>Data Source=c:\temp\nwind\Nwind.accdb</ConnectionString>
</AccessImporter>

Example:

 <cf:entity name="User" directoryEntityType="User">
  <cf:property name="Id" typeName="guid" cfps:rowguidcol="true" />
  <cf:property name="Login" collectionKey="true" />
  <cf:property name="Password" />
  <cf:property name="Email" />
   ... other properties ...
  <cf:property name="Roles" typeName="UserRoleCollection" />
 </cf:entity>

 <cf:entity name="Role" directoryEntityType="Role" >
  <cf:property name="Id" typeName="guid" cfps:rowguidcol="true" />
  <cf:property name="Name" collectionKey="true" />
  <cf:property name="Users" typeName="UserRoleCollection" />
   ... other properties ...
 </cf:entity>

 <cf:entity name="UserRole">
  <cf:property name="Id" typeName="guid" cfps:rowguidcol="true" />
  <cf:property name="User" typeName="User" />
  <cf:property name="Role" typeName="Role" />
   ... other properties ...
 </cf:entity>

The Actions menu now works as expected

Example 1:
    <cf:method name="Test1" body="raw(char separator)">
        <cf:parameter name="separator" cfps:dataType="nchar" />
    </cf:method>

Example 2:
    <cf:userType name="sqlchar" typeName="char" cfps:dataType="nchar"/>
    <cf:method name="Test2" body="raw(sqlchar separator)" />

Office synchronization feature now supports Microsoft Access 2007, Microsoft Excel 2003/2007 for front ends. Back end can be IIS based or WCF (ServiceHost) based.

The new SQL2008 hierarchyId type is not supported by DMO, which is used by this importer. The new version shipped with this build now raises a warning but continues. Note this importer is obsolete, you should use the new one: "CodeFluent.Importers.Database.SqlServerImporter, CodeFluent.Importers.Database".

The new importer can successfully import the model, but fails to generate because CodeFluent does not support hierarchyid as valid type for key columns. You can override the default importer types by adding a custom TypeMapper for the hierarchyid type. You can also patch the generated model manually. The following example associates hierarchyid with the string type:
<?xml version="1.0" encoding="utf-8"?>
<SqlServerImporter xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Verbosity>0</Verbosity>
  <Project>
 <DefaultNamespace>AdventureWorks2008</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute>
  <Name>MustCreateDefaultApplication</Name>
  <Value>false</Value>
   </Attribute>
   <Attribute>
  <Name>MustCreateDefaultHints</Name>
  <Value>false</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultMaxLength</Name>
  <Value>64</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultTrackingModes</Name>
  <Value>None</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultConcurrencyMode</Name>
  <Value>None</Value>
   </Attribute>
   <Attribute>
  <Name>DefaultPersistenceUnicode</Name>
  <Value>true</Value>
   </Attribute>
   <Attribute>
  <Name>defaultBindingList</Name>
  <Value>false</Value>
  <Namespace>http://www.softfluent.com/codefluent/producers.model/2005/1</Namespace>
   </Attribute>
 </Attributes>
  </Project>
  <Entity>
 <Attributes>
   <Attribute>
  <Name>ConcurrencyMode</Name>
  <Value>None</Value>
   </Attribute>
   <Attribute>
  <Name>TrackingModes</Name>
  <Value>None</Value>
   </Attribute>
 </Attributes>
  </Entity>
  <TypeMappers>
    <TypeMapper>
    <DataType>hierarchyid</DataType>
    <TypeName>string</TypeName>
    </TypeMapper>
  </TypeMappers>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>40000</MaxEntities>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>server=myserver\SQL2008;database=AdventureWorks2008;Integrated Security=true</ConnectionString>
</SqlServerImporter>

This may cause compilation errors with the generated model files.

Previous builds did not detected recent versions of Graphviz.

This method is used to reset the CodeFluent thread owned underlying ADO.NET connection. It can be only in database connection exception handling.

Note: the client app.config may need to be changed to work with the newly generated proxy classes, in the case of entities with binary large object properties. Take a look at the Templates\ServiceModel\Client\[Template]App.config file provided with CodeFluent for change details.

Set the 'autoStartsWith' attribute to 'true' on method, entity or project node. Example:
 <Customer >
  <Id />
  <FirstName />
  <LastName />
  <cf:method name="SearchAutoStartWith" body="search(*)" autoStartsWith="true" />
 </Customer>

Use the boolean 'rowguidcol' attribute in the SQL Server producer specific XML namespace. Note: this attribute is not handled by the producer diff engine, it has to be present when the table is created. Example:
<Customer>
 <Id typeName="guid" cfps:rowguidcol="true" />
</Customer>

The workaround was to set the AutoEnlistTransaction property to true on the CodeFluent persistence instance.

Custom scripts need to have the same name as the standard scripts, in the same directory, but prefixed with 'before_' or 'after_'. For example, if a project has a 'SoftFluent.CarRental' default namespace, a file script named 'after_SoftFluent.CarRental_runtime.sql' will be executed after the standard 'SoftFluent.CarRental_runtime.sql'.

This flag is similar to the CreationState flags. It is used by the model producer for the EntityState property code generation. If this flag is set, an EntityState with a ToBeDeleted value will keep this value even if the holding entity instance properties are modified. Note: the default value for entityTrackingModes attribute is now "Time,User,CreationState,DeletionState".

You need to add the 'produceSchemas' to the producer configuration and set it to 'true'. The default value is 'false'. Schema owner can optionally be specified on the schema node (in this case, the schema node needs to be explicit) using the producer XML namespace. The default value is 'dbo'. Exemple:

<cf:schema name="Sales" cfps:owner="dbo" />
<Customer schema="Sales" >
 <Id />
 <Name />
</Customer>

Note: a new flag 'EntityKeyCheck' has been added to the PropertyTrackingModes enumeration. It is by default enabled for the new behavior, so if 'trackingModes' at property node level or 'defaultPropertyTrackingModes' attributes at entity and project level are redefined, this flag needs to be added as well in the redefinition.
Revision: return case has been modified to copy the existing relation object if it exists and matches the current identifiers.

Dynamic ORDER BY are created when properties are defined as sortable. To define properties as sortable, you can use the 'sortable' attribute at property level, or 'defaultSortable' at entity and project levels. LOAD methods currently support only one dynamic ORDER BY parameter, but SEARCH methods support a variable number of dynamic ORDER BY parameters. The number of dynamic ORDER BY parameters can be specified at method ('persistenceOrderByParametersCount' attribute), entity or project level ('defaultPersistenceOrderByParametersCount' attribute). Example:
   <Customer defaultSortable="true" >
      <Id />
      <cf:method name="SearchByName" persistenceOrderByParametersCount="5" body="search()" />
   </Customer>

Added the 'nullValidate' attribute in the Model producer XML namespace to prevent local null validation for the Model producer. The exact same attribut in the same namespace can be used at entity or project level. Example:

   <Customer>
      <Id cfom:nullValidate="false" />
   <Customer>

   <Customer cfom:nullValidate="false">
      <Id />
   <Customer>

The CodeFluent.Runtime.Utilities.Country class now defines

public static Country[] GetCurrencyCountries(string isoCurrencySymbol)
-> gets the list of countries using a given currency

public static Country[] AllCountries 
-> gets the list of countries installed in the system

Set the new 'identityModes' attribute to "None" at entity node level, or 'defaultIdentityModes' to 'None' at the project node level. Note: deactivating the IEquatable implementation also deactivates the System.Object.Equals standard override.

To create a localized value in an instance, add an Xml element like an instance value, in the localization pattern Xml namespace. The local name of the element must match the name of localized property. The 'cultureName' attribute determines the locale to use. Example:

<Product>
   <Id />
   <Description loc:localizable="true" />
   <cf:instance><Id>1</Id><loc:Description cultureName="1033">This is a product</loc:Description><loc:Description cultureName="1036">Ceci est un produit</loc:Description></cf:instance>
</Product>

Default value are also supported, using standard instance value notation. Exemple:
   <cf:instance><Id>1</Id><Description>This is the default value</Description><loc:Description cultureName="1033">This is a product</loc:Description><loc:Description cultureName="1036">Ceci est un produit</loc:Description></cf:instance>

At runtime, CodeFluent throws an exception when generated CodeFluent code tries to enlist in nested transactions. Example:

using (TransactionScope scope = new TransactionScope())
{
   Succeed1();
   using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
   {
         Succeed2();
         scope2.Complete();
   }
   Fail();
   scope.Complete();
}

In this exemple, nothing commits, because the call to Succeed2() raises a CodeFluentRuntimeException (nested transactions are not allowed on the same CodeFluent Context). To make it work as expected, use the following syntax:

using (TransactionScope scope = new TransactionScope())
{
   Succeed1();
   using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
   {
      CodeFluentContext.Get(Constants.<your namespace>).RunOnNew(delegate()
      {
         Succeed2();
      });
      scope2.Complete();
   }
   Fail();
   scope.Complete();
}
In this case, Succeed2() runs on a new transient CodeFluent context.

At runtime, CodeFluent now throws an exception when generated CodeFluent code tries to enlist in nested transactions. Example:

using (TransactionScope scope = new TransactionScope())
{
   Succeed1();
   using (TransactionScope scope2 = new TransactionScope(TransactionScopeOption.RequiresNew))
   {
         Succeed2();
         scope2.Complete();
   }
   Fail();
   scope.Complete();
}

Previously, with this exemple, nothing commited, because Succeed2() is enlisted in scope, not scope2. Starting with this build, Succeed2() now raises a CodeFluentRuntimeException. See Task3231 to see how to use nested TransactionScopes with CodeFluent, to make sure Succeed2() commits.

Note: a new flag 'EntityKeyCheck' has been added to the PropertyTrackingModes enumeration. It is by default enabled for the new behavior, so if 'trackingModes' at property node level or 'defaultPropertyTrackingModes' attributes at entity and project level are redefined, this flag needs to be added as well in the redefinition.
Revision: return case has been modified to copy the existing relation object if it exists and matches the current identifiers.

Add the 'returnOnDefaultKeyValue' attribute in the Model producer namespace and set it to 'false' (the default is 'true') to remove the default value equality check. Exemple:
 <cf:method name="LoadByEntityArg" body="loadone(Customer) where Customer = @Customer">
    <cf:parameter name="Customer" cfom:returnOnDefaultKeyValue="false" cfom:xmlns="http://www.softfluent.com/codefluent/producers.model/2005/1"/>
 </cf:method>

This is based on Graphviz, that needs to be installed first. see http://www.graphviz.org for information.

Command line example:
Codefluent.import.exe "CodeFluent.Importers.Database.AccessImporter, CodeFluent.Importers.Database" Northwinds.Access.Importer.xml

Xml file example:
<?xml version="1.0" encoding="utf-8"?>
<AccessImporter>
  <Project>
 <DefaultNamespace>Northwinds</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute><Name>MustCreateDefaultApplication</Name><Value>false</Value></Attribute>
   <Attribute><Name>MustCreateDefaultHints</Name><Value>false</Value></Attribute>
   <Attribute><Name>DefaultMaxLength</Name><Value>64</Value></Attribute>
   <Attribute><Name>DefaultTrackingModes</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultPersistenceUnicode</Name><Value>true</Value></Attribute>
 </Attributes>
  </Project>
  <Entity>
 <Attributes>
   <Attribute><Name>ConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>TrackingModes</Name><Value>None</Value></Attribute>
 </Attributes>
  </Entity>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>40000</MaxEntities>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>Data Source=c:\temp\nwind\Nwind.accdb</ConnectionString>
</AccessImporter>

Command line example:
Codefluent.import.exe "CodeFluent.Importers.Database.OleDbImporter, CodeFluent.Importers.Database" MyOleDbDatabase.Importer.xml

Xml file example:
<?xml version="1.0" encoding="utf-8"?>
<OleDbImporter>
  <Project>
 <DefaultNamespace>MyDatabase</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute><Name>MustCreateDefaultApplication</Name><Value>false</Value></Attribute>
   <Attribute><Name>MustCreateDefaultHints</Name><Value>false</Value></Attribute>
   <Attribute><Name>DefaultMaxLength</Name><Value>64</Value></Attribute>
   <Attribute><Name>DefaultTrackingModes</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultPersistenceUnicode</Name><Value>true</Value></Attribute>
 </Attributes>
  </Project>
  <Entity>
 <Attributes>
   <Attribute><Name>ConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>TrackingModes</Name><Value>None</Value></Attribute>
 </Attributes>
  </Entity>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>40000</MaxEntities>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>Provider=[OLEDB Provider name];[OLEDB Properties]</ConnectionString>
</OleDbImporter>

Command line example:
Codefluent.import.exe "CodeFluent.Importers.SqlServerCeImporter, CodeFluent.Importers.SqlServerCe" Northwinds.SqlServerCe.Importer.xml

Xml file example:
<?xml version="1.0" encoding="utf-8"?>
<SqlServerCeImporter>
  <Project>
 <DefaultNamespace>Northwinds</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute><Name>MustCreateDefaultApplication</Name><Value>false</Value></Attribute>
   <Attribute><Name>MustCreateDefaultHints</Name><Value>false</Value></Attribute>
   <Attribute><Name>DefaultMaxLength</Name><Value>64</Value></Attribute>
   <Attribute><Name>DefaultTrackingModes</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultPersistenceUnicode</Name><Value>true</Value></Attribute>
 </Attributes>
  </Project>
  <Entity>
 <Attributes>
   <Attribute><Name>ConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>TrackingModes</Name><Value>None</Value></Attribute>
 </Attributes>
  </Entity>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>40000</MaxEntities>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>Data Source=Northwind.sdf</ConnectionString>
</SqlServerCeImporter>

By default, it is not generated. Add a boolean 'produceWebMembershipUser' attribute set to 'true' to force its generation. Note this is a breaking change, as the default was to generate it.

<cf:producer name="Model" typeName="CodeFluent.Producers.CodeDom.CodeDomProducer, CodeFluent.Producers.CodeDom">
  <cf:configuration produceWebMembershipUser="true" ... />

Command line example:
Codefluent.import.exe "CodeFluent.Importers.Database.OracleImporter, CodeFluent.Importers.Database" HR.Oracle.Importer.xml

Xml file example:
<?xml version="1.0" encoding="utf-8"?>
<OracleImporter>
  <Project>
 <DefaultNamespace>Oracle.Hr</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute><Name>MustCreateDefaultApplication</Name><Value>false</Value></Attribute>
   <Attribute><Name>MustCreateDefaultHints</Name><Value>false</Value></Attribute>
   <Attribute><Name>DefaultMaxLength</Name><Value>64</Value></Attribute>
   <Attribute><Name>DefaultTrackingModes</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultPersistenceUnicode</Name><Value>true</Value></Attribute>
 </Attributes>
  </Project>
  <Entity>
 <Attributes>
   <Attribute><Name>ConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>TrackingModes</Name><Value>None</Value></Attribute>
 </Attributes>
  </Entity>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>40000</MaxEntities>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <SchemaIsNamespace>false</SchemaIsNamespace>
  <ConnectionString>SERVER=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=SFSMO-ORA)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)));uid=hr;pwd=hr</ConnectionString>
</OracleImporter>

The .chm file is copied in the installation directory. Note: no icon / shortcut is created in the CodeFluent start menu.

Example of an importer file for AdventureWorks database. Note the defaultBindingList attribute, in the CodeDom (Model) producer namespace:

<?xml version="1.0" encoding="utf-8"?>
<SqlImporter xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
  <Verbosity>0</Verbosity>
  <Project>
 <DefaultNamespace>AdventureWorks</DefaultNamespace>
 <SaveOptions>Free</SaveOptions>
 <Attributes>
   <Attribute><Name>MustCreateDefaultApplication</Name><Value>false</Value></Attribute>
   <Attribute><Name>MustCreateDefaultHints</Name><Value>false</Value></Attribute>
   <Attribute><Name>DefaultMaxLength</Name><Value>64</Value></Attribute>
   <Attribute><Name>DefaultTrackingModes</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>DefaultPersistenceUnicode</Name><Value>true</Value></Attribute>
   <Attribute><Name>defaultBindingList</Name><Value>false</Value><Namespace>http://www.softfluent.com/codefluent/producers.model/2005/1</Namespace></Attribute>
 </Attributes>
  </Project>
  <Entity>
  <Attributes>
    <Attribute><Name>ConcurrencyMode</Name><Value>None</Value></Attribute>
   <Attribute><Name>TrackingModes</Name><Value>None</Value></Attribute>
 </Attributes>
  </Entity>
  <CreatePrimaryKeyColumn>false</CreatePrimaryKeyColumn>
  <MaxEntities>40000</MaxEntities>
  <KeyFormat>{0}_id</KeyFormat>
  <GeneratedKeyFormat>{0}Id</GeneratedKeyFormat>
  <CultureName>en-US</CultureName>
  <RemovePlural>true</RemovePlural>
  <CamelizeNames>true</CamelizeNames>
  <ConnectionString>server=127.0.0.1\SQL2005;database=AdventureWorks;Integrated Security=true</ConnectionString>
</SqlImporter>

A new attribute 'lcidExpression' can be added to the pattern import Xml element. The default is 'System.Threading.Thread.CurrentThread.CurrentUICulture.LCID'. The following example uses the CurrentCulture instead of the CurrentUICulture:

<cf:import ...\SoftFluent.Localization.xml" runTemplate="true" lcidExpression="System.Threading.Thread.CurrentThread.CurrentCulture.LCID" />

CodeFluent is now capable of detecting processes opening files, with exception CF1046. Example:
CodeFluentRuntimeException: CF1056: The process cannot access the file 'C:\MyModel\Model\Customer.cs' because it is being used by another process. This is list of detected processes opening this file: [WINWORD.EXE 14236].
This advanced detection requires admin rights. It requires the sysinternals HANDLE.EXE tool to be installed in the PATH. Available at http://live.sysinternals.com/

Note localizable properties cannot be declared as persistenceNullable (or implicitly by using the 'nullable' attribute). Previous versions actually created nullable columns which resulted in runtime database errors. This version now silently forces localizable properties not to be nullable.

The exception is now a NotSupportedException, as this combination is actually invalid.

Example configuration:

<cf:producer name="WSS" typeName="CodeFluent.Producers.SharePoint.WebPartsProducer, CodeFluent.Producers.SharePoint">
 <cf:configuration  targetDirectory="{0}\SPWebParts"
  sharePointDirectory="\\WSS-Server\c$\Inetpub\wwwroot\wss\VirtualDirectories\80"
  connectionString="Application Name={0};server=%COMPUTERNAME%;database={0};user id=test;password=test" />
</cf:producer>
the 'sharePointDirectory' attribute must match the target WSS or MOSS virtual root.
the 'connectionString' (optional) will be used by the SharePoint generated WebParts to connect to the database.

Example:
<cf:entity lightWeight="true" name="Point">
  <X typeName="int" />
  <Y typeName="int" />
</cf:entity>

Supports mapping to existing types as well:

  <cf:entity name="CultureInfo" namespace="System.Globalization" typeName="System.Globalization.CultureInfo"
   cfom:initExpression="System.Threading.Thread.CurrentThread.CurrentCulture"
   cfom:readRecordExpression="this.{0} = System.Globalization.CultureInfo.GetCultureInfo({LCID});"
   >
  <LCID defaultValue="127" />
 </cf:entity>

 <Rectangle namespace="System.Drawing, System.Drawing"> <!-- because Rectangle has a parameterless constructor and a properties matching constructor, there is no need to declare initExpression nor readRecordExpression -->
  <X />
  <Y />
  <Height />
  <Width />
 </Rectangle>

For existing entities such as CultureInfo & Rectangle, no class is generated by the CodeDom producer.

Allows simplified 1:1 asymmetric relations:
 <MyEntity>
  <Point typeName="Point" /> <!-- will store X & Y in the MyEntity table columns -->
  <Culture typeName="System.Globalization.CultureInfo" /> <!-- will store LCID in the MyEntity table columns -->
  <Rectangle typeName="System.Drawing.Rectangle" />  <!-- will store X, Y, Height & Width in the MyEntity table columns -->
 </MyEntity>

Example:
 <Rectangle namespace="System.Drawing, System.Drawing" >
  <X />
  <Y />
  <Height />
  <Width />
  <cf:method name="RawMinRectangles" body="raw(int minWidth)" rawBody="select 1 as $Rectangle::X$, 2 as $Rectangle::Y$" />
  <cf:method name="LoadMinRectangles" body="load(int minWidth) raw" rawBody="select 1 as $Rectangle::X$, 2 as $Rectangle::Y$" />
 </Rectangle>

In this exemple, a LightWeight entity is created as the result from a view. The view is itself generated as a SQL view (NOTE: the SQL producer must be configured with the attribute produceViews='true'). A custom method is defined, and since its source is this view, it will return a List of ArticleQuantity instances, instead of an ArticleCollection.

<Article>
 <Id />
 <Name />
 <Lines typeName="LineCollection" />
 <cf:method name="LoadArticlesByCommand" body="load(Command command) from ArticleQuantity where Command = @command" /> <!-- the method uses the view defined below -->
  <cf:view name="ArticleQuantity" autoLightWeight="true"> <!-- this view creates a LightWeight entity named ArticleQuantity -->
    <Id />
    <Name />
    <Quantity expression="Lines.Quantity" />
    <Command expression="Lines.Command" />
  </cf:view>
 <cf:instance><Id>1</Id><Name>Bike</Name></cf:instance>
 <cf:instance><Id>2</Id><Name>Car</Name></cf:instance>
 <cf:instance><Id>3</Id><Name>Truck</Name></cf:instance>
</Article>

<Command>
 <Id />
 <Name collectionKey="true" />
 <Lines typeName="LineCollection" />
 <cf:instance><Id>1</Id><Name>Joe</Name></cf:instance>
 <cf:instance><Id>2</Id><Name>Sam</Name></cf:instance>
 <cf:instance><Id>3</Id><Name>Bill</Name></cf:instance>
</Command>

<Line setType="List"> <!-- this is an assocation table, with a composite object key -->
 <Article typeName="Article" key="true" />
 <Command typeName="Command" key="true" />
 <Quantity typeName="int" />
 <cf:instance><Article>1</Article><Command>1</Command><Quantity>10</Quantity></cf:instance>
 <cf:instance><Article>2</Article><Command>1</Command><Quantity>20</Quantity></cf:instance>
 <cf:instance><Article>2</Article><Command>2</Command><Quantity>15</Quantity></cf:instance>
</Line>

A new attribute 'saveDefaultLcidExpression' can be added to the pattern import Xml element. In this example, the lcid used for the test represents the machine installed UI culture:

<cf:import path="...\SoftFluent.Localization.xml" runTemplate="true" saveDefaultLcidExpression="System.Globalization.CultureInfo.InstalledUICulture.LCID" />

If defined, the expression will be directly injected into the SaveLocalizedValues() method. The expression must be compilable by the target compiler.

A new attribute 'autoSave' can be added to the pattern import Xml element. The default is 'true'. In this example, the OnAfterSave rule is not created:

<cf:import path="...\SoftFluent.Localization.xml" runTemplate="true" autoSave="false" />

A new attribute 'lcidPropertyName' can be added to the pattern import Xml element. The default is 'Lcid'. Example:

<cf:import path="...\SoftFluent.Localization.xml" runTemplate="true" lcidPropertyName="LocaleId" />

Note: LightWeight entities generated as structs are not supported by the cache producer

Exemple:

 <cf:entity name="Point" cfom:struct="true" lightWeight="true">
  <Latitude typeName="float" />
  <Longitude typeName="float" />
 </cf:entity>

This is done by adding an attribute suffixed with -typeName that contains the parameter target type name. How the parameter string value is converted at parsing / compile time into a value of this target type depends on the culture of the project, but will not therefore depends on the runtime culture.

Exemple:
 <Customer>
  <RebateRatio typeName="decimal">
   <cf:rule typeName="CompareValidate" operator="BetweenEqual" minimumValue="0,5" maximumValue="1,6"  maximumValue-typeName="decimal"  minimumValue-typeName="decimal" />
  </RebateRatio>

The default value is false. Example:

  <Customer>
    <cf:rule typeName="OnAfterSave" />
  <Customer>

Will generate this for the Save() method:
        public virtual bool Save()
        {
            bool localSave = this.BaseSave(false);
            return localSave;
        }
and
  <Customer>
    <cf:rule typeName="OnAfterSave" checkReturn="true" />
  <Customer>

Will generate this for the Save() method:
        public virtual bool Save()
        {
            bool localSave = this.BaseSave(false);
            if (localSave) this.OnAfterSave();
            return localSave;
        }

The pattern will add a DeepLoad method to the collection class for all hierarchy base entities.

Example:
 <cf:import path="%ProgramFiles%\SoftFluent\CodeFluent\Current\Patterns\SoftFluent.HierarchyDeepLoad.xml" runTemplate="true" step="Methods" />

Example:
  <cf:method name="MyMethod" body="load() where ..." >
    <cf:rule typeName="PrincipalPermission" authenticated="true" role="Administrators"  />
    <cf:rule typeName="PrincipalPermission" authenticated="true" role="Power users"  />
  </cf:method>

Example:
<Customer>
  <CreationDate>
   <cf:rule typeName="OnCreate" expression="System.DateTime.Now" />
  </CreationDate>
</Customer>

and

<cf:userType name="DateNow" typeName="DateTime">
   <cf:rule typeName="OnCreate" expression="System.DateTime.Now" />
</cf:userType>

This attribute forces the 'modelNullable' attribute to true for 'nullable' value type properties in a given entity or per project.

It is a sub producer of the Model producer. Configuration example:
  <cf:producer name="Model" typeName="CodeFluent.Producers.CodeDom.CodeDomProducer, CodeFluent.Producers.CodeDom">
    <cf:configuration outputName="..\bin\{0}.dll" targetDirectory="{0}\Model">
      <subProducer typeName="CodeFluent.Producers.Linq.LinqMappingProducer, CodeFluent.Producers.Linq" />
    </cf:configuration>
  </cf:producer>

Usage examples:

<%@ Register TagPrefix="cf" Namespace="CodeFluent.Runtime.Web.UI.WebControls" Assembly="CodeFluent.Runtime.Web" %>
<cf:EnumDropDownList runat="server" EnumTypeName="System.DayOfWeek" Value="Thursday" SortExpression="Value" />
<cf:EnumCheckBoxList runat="server" EnumTypeName="System.UriComponents" Value="StrongAuthority" DecamelizeOptions="Default" />

This is due to a regression in foreach handling with COM objects under Windows Vista. see here  http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=330906

This is due to a regression in foreach handling with COM objects under Windows Vista. see here  http://connect.microsoft.com/VisualStudio/feedback/ViewFeedback.aspx?FeedbackID=330906

exemple:
<cf:method name="LoadByNameAndAge" body="load(string name, int age) where Name = @name and Age > @age">
  <cf:form name="Custom">
    <cf:tab name="General">
      <cf:column>
        <cf:field name="name" />
      </cf:column>
      <cf:column>
        <cf:field name="age" />
      </cf:column>
    </cf:tab>
  </cf:form>
</cf:method>

Added Reset() and SafeClose() methods to CodeFluent's Enhanced Proxy WcfClient and WcfBinaryClient inner classes.
Added CodeFluent.Runtime.ServiceModel.ServiceModelUtilities.ISafeClosable interface implementation for these classes.
Added the SafeClosables field to the Constants generated class.

This allows a global safe close (especially for NetTcpBinding usage). Exemple:
CodeFluent.Runtime.ServiceModel.ServiceModelUtilities.SafeClose(SoftFluent.CarRental.Proxy.Constants.SafeClosables);

Added helper methods for global WCF channel closing.

/// Safely closes an array of clients.
public static void SafeClose(ISafeClosable[] closables)

/// Safely closes a list of clients.
public static void SafeClose(IEnumerable<ISafeClosable> closables)

/// Safely closes a WCF client. See http://msdn.microsoft.com/en-us/library/aa355056.aspx for more information.
public static Exception SafeClose<T>(ClientBase<T> client) where T : class

/// Safely closes a WCF client. See http://msdn.microsoft.com/en-us/library/aa355056.aspx for more information.
public static Exception SafeClose<T>(ClientBase<T> client, bool throwOnException) where T: class