MyMeta DataTypeName Incorrect

[alphonse]

First I want to say how great MyGeneration is, especially for the price.
It has saved countless hours of time as well as keeping my code and procs consistant.

Using SQL Server 2005, DataTypeName and DataTypeNameComplete return 'text' for the new varchar(max) data type.

[justin.greenwood]

thanks for the heads up on that. we will look into that for the next build. I know mike is working on adding a plugin for SQL Server CE, so he may also be able to nail that. one of us at least should be able to get it.

[Joe Kalinowski]

Is there an update for when support will be added for the Sql Server 2005 varchar(max), nvarchar(max), and varbinary(max) data types?

[bdfranson]

Would be really nice to get this - text fields are deprecated in SQL Server 2005 and replaced with the new fields.

Please let us know when there will be an update!

Thanks - great product!

[bdfranson]

Sorry - was looking a bit more into this.

The specification for the fields should be (SqlDbType is per Microsoft):

varchar(max)
DataTypeName: varchar
DataTypeNameComplete: varchar(max)
DbTargetType: SqlDbType.Text

nvarchar(max)
DataTypeName: nvarchar
DataTypeNameComplete: nvarchar(max)
DbTargetType: SqlDbType.NText

varbinary(max)
DataTypeName: varbinary
DataTypeNameComplete: varbinary(max)
DbTargetType: SqlDbType.Image

[jamieb]

Are there any updates on this ?

workaround if it's of use: (VB.Net)

[code]
Function DataTypeNameComplete(ByVal c As Column) As String
If c.DataTypeNameComplete = \"ntext\" AndAlso c.CharacterMaxLength = 0 Then Return \"nvarchar(MAX)\"
If c.DataTypeNameComplete = \"text\" AndAlso c.CharacterMaxLength = 0 Then Return \"varchar(MAX)\"
If c.DataTypeNameComplete = \"image\" AndAlso c.CharacterMaxLength = 0 Then Return \"varbinary(MAX)\"

Return c.DataTypeNameComplete

End Function
[/code]

[justin.greenwood]

I am hitting mygen 1.3 hard, so I will look into adding this support.

[justin.greenwood]

fixed - this was a pain because varchar(max) seems to just be an alias for the datatype (text) you were seeing. Anway, I fugred out where to get it and I put it in there - I imagine some people would prefer the translated types.