MySql and SByte

[mosenturm]

Hi,

this is the first time that I use MyGeneration to generate dOOdads BE. Thanks for the great software!
But ... we've got a problem ...

I get the error:

Code: Select all

error BC30456: \"GetSByte\" isn't a Member of \"MyGeneration.dOOdads.MySql4Entity\".
Return MyBase.GetSByte(ColumnNames.Active)

If I change the mapping to TINYINT to Byte there is no error while compile time. (MySQL 2 Language Mapping / MySql Connector.NET VB.NET)
Now I get an error on runtime:

Code: Select all

System Invalid Cast Exception: Invalid Type Casting from Type 'SByte' to Type 'Byte'

EDIT:
The Debugger shows the error in BusinessEntity.vb at:

Code: Select all

' Byte (real)
        Protected Function GetByte(ByVal columnName As String) As Byte
            Return CType(_dataRow(columnName), Byte)
        End Function

What's going wrong?
Thanks for any help!

Andreas

[mike.griffin]

Andreas, I must have forgotten to add that to the VB.NET BusinessEntity class, open your BusinessEntity.vb class in your MyGeneration.dOOdads project and clone GetByte and SetByte and create GetSByte and SetSByte changing the types to SByte where appropriate, I will make the same changes here, a minor maintenance release will come out in April with this fix. Please let me know the outcome.

[mosenturm]

Hi Mike,

I've copied the GetByte/SetByte and the GetByteAsString/SetByteAsString functions in BusinessEntity.vb to GetSByte/SetSByte and GetSByteAsString/SetSByteAsString and changed the type Byte in SByte. Now everything is working fine.

You can download the file at http://www.vocote.de/test/BusinessEntity.vb
Thanks!
Andreas

[mark100net]

Also using MySQL2 (but with C#) I had a similar problem where compilation failed due to the absence of the following methods:

GetsbyteAsString
SetsbyteasString
GetushortAsString
SetushortAsString

I followed the approach in Mike's previous post, making the changes in BusinessEntity.cs and it seems to work so far.

Let me know if you want me to send you the revised file.

Mark

[mike.griffin]

mosenturm, I got your changes in. Now, mark100net can you post the code to those four C# methods I'll get them in, I'm preparing the next release so any help is appreciated, I could recreate them but I'm going to wait for you to post them and move on to my next issues, thanx guys !

[marclar]

Hi, everyone -- I still had problems with Andreas' BusinessEntity.vb file, so I put one here:

http://marclar.posterous.com/mygeneration-fix