Home > News, SQLAzure > CodeFluent Entities SQL Azure Producer Unveiled!

CodeFluent Entities SQL Azure Producer Unveiled!

I am really excited to announce today the forthcoming support of Microsoft SQL Azure in CodeFluent Entities.

What is Microsoft SQL Azure?

Microsoft® SQL Azure™ Database is a cloud-based relational database service (RDBMS) built on SQL Server® technologies. It is a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. SQL Azure Database helps to ease provisioning and deployment of multiple databases. Developers do not have to install, setup, patch or manage any software, as all that is taken care of by Microsoft with this platform as a service (PAAS). High availability and fault tolerance is built-in and no physical administration is required.

More information here (official Microsoft SQL Azure website).

What is CodeFluent Entities SQL Azure Producer ?

CodeFluent Entities SQL Azure Producer allows you to easily generate code for Microsoft SQL Azure databases. The generated code is fully compatible with the Business Object layer generated by the CodeFluent Entities BOM Producer.

The SQL Azure producer brings many benefits including:

  • Ability to develop your application on a local MS SQL Server and deploy it to SQL Azure only when you decide it. This is a key feature that will save you money as you will not consume SQL Azure resources during development phase
  • Ensure reversibility in your application as you will be able to select the SQL Server Producer (or Oracle Producer) at any time and regenerate the persistence layer without any impact on the existing application
  • Access your SQL Azure database and data using the integrated database explorer available in CodeFluent Entities Modeler
    The next CodeFluent Entities build planned for March 2011 will include a beta version of this new producer.

In the meantime, check out this video preview!

SQL Azure Producer Preview – Watch on Youtube in 720p for high quality video


More on : http://www.codefluententities.com (click Get Started)


  1. João Rodrigues
    February 25, 2011 at 5:44 pm

    Hi Omid,

    This is awesome! I’m really excited to start using this new producer.
    How will it handle file type properties?


    • softfluent
      March 7, 2011 at 11:34 am

      Hi Joao,

      What do you mean by file type properties? You will still be able to set properties typenames as usual and the Azure producer will handle it the same way the standard SQL server producer does it.


  2. João Rodrigues
    March 7, 2011 at 7:53 pm

    Hi Omid,

    As you might know, our project involves a lot of files storage and Azure SQL databases are limited to 50Gb. Thereby it becomes kind of limiting to store files in the database (This is what happens if I define a property of type file, document or image for a given entity in the XML Model).

    The solution to this problem would be to use Azure Storage Blobs in order to store these files. So I was wondering if this new producer will support this kind of situations. It’s really handy to use the BinaryLargeObject class provided by CodeFluent and I don’t see how I can make it possible without defining a property of type file, document or image.

    I know this is an Azure SQL Producer and the aim of this producer is to provide an easy with Azure SQL. But this was just a concern I had.

    Sorry if this isn’t the more suitable place to ask these questions.


  3. softfluent
    March 8, 2011 at 1:52 pm

    Hi Joao,

    Indeed, one of the main benefits of CodeFluent Entities is to ease your life when dealing with BLOBs. The SQL Azure producer will allow to store BLOB properties (image, file, document, etc) in SQL Azure but also in Windows Storage! This will only be a matter of configuration:).

    We’re currently working hard to finalize this producer and plan to release a new build containing this new producer along with other new features, at the end of this month.


  1. February 24, 2011 at 1:00 pm
  2. March 10, 2011 at 11:45 pm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s