some types are not supported?

Jun 30, 2012 at 12:37 PM

context.Update("Table").Column("Col1", value).Where("ID", 1).Execute();

if value is nullable like decimal?, float?, it will cause an error.

and value is float or double type, it will cause an error too...

Jul 1, 2012 at 10:17 AM

I have checked the code. It seems the fix I did to solve this issue was not optimal. I have a better fix that will finally solve this, but I'm on holiday until Thursday so I won't get to fix this until Thursday evening. I will notify you when it's fixed.

Jul 11, 2012 at 7:25 AM

What database do you use? Can you please paste your database table and your .NET code? Then I can verify that the fix works...

Jul 11, 2012 at 9:38 AM

Mysql5.5 and Sql Server 2005.


Table Structure:



CREATE TABLE `table1` (
  `C1` float DEFAULT NULL,


-----Sql Server----

C1 is a Real.



FluentData.IDbContext context = new FluentData.DbContext().ConnectionString("server=localhost;User Id=root;password=111;Persist Security Info=True;database=test", FluentData.DbProviderTypes.MySql);

float c1 = 12.12F;
context.Insert("Table1").Column("C1", c1).ExecuteReturnLastId();



Error: The parameter c0 is of a type that is not supported.

Besides, InsertBuilder has no method 'Execute' ? I always use Guid for the key..

Jul 11, 2012 at 7:37 PM

This issue should hopefully be fixed now. I tested it against SQL-Server and it works. I've made a new release for you, it's marked as beta since there are some new functionality in there (a Select builder that might not be 100% stable yet). Get it from:

I will be on holiday for the next 2 weeks. When I'm back I will will make a new stable release.

Jul 11, 2012 at 9:11 PM

... And Execute() has been added to the InsertBuilder.