Have you tried SqlType="IMAGE" ? Not sure if that will help (I thought the SqlLite blob type was "BLOB"?) - I generally use SqlCe for my integration tests that include blobs. Cheers,
- Alex On Mon, Jul 27, 2009 at 1:39 AM, Daniel Hölbling <[email protected]>wrote: > Hi, > I'm trying to map binary data to the database. > I tried using SqlType = "varbinary(MAX)", but that breaks all of my SqlLite > testcases (SQLite error near "MAX": syntax error). > > So I figured it should be possible to just lookup what numeric value MAX is > and assign that explicitly. > According to Sql Server 2008 books its 2147483647 ( > http://msdn.microsoft.com/en-us/library/ms188362.aspx) and I changed my > mapping to look like this: > > [Property(ColumnType = "BinaryBlob", SqlType = "varbinary(2147483647)")] > public byte[] BinaryData { get; set; } > > Now the whole thing fails during Schema export with the following error: > *The size (2147483647) given to the column 'BinaryData' exceeds the > maximum allowed for any data type (8000).* > Has anyone else encountered this and possibly found a solution to the > problem? > > greetings, > Daniel Hölbling > http://www.tigraine.at > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Castle Project Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/castle-project-users?hl=en -~----------~----~----~----~------~----~------~--~---
