google-code-export / dblinq2007

Automatically exported from code.google.com/p/dblinq2007
Other
0 stars 0 forks source link

DBMetal enum field not supporterd #267

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. mysql Fieldtype = enum("1","0")
2. create .vb en .dbml file for database
3.

What is the expected output? What do you see instead?
An 0 bytes vb-file is created

What version of the product are you using? On what operating system?
latest svn download

Please provide any additional information below.
On line 755 of CodeDomGenerator.cs:
->  var fieldType = TypeLoader.Load(column.Type);
column.Type = "EdInRSActiveType 0, 1" which results in fieldType being null

My table:
CREATE TABLE IF NOT EXISTS `users` (
  `naam` varchar(50) NOT NULL DEFAULT '',
  `adres` varchar(50) NOT NULL DEFAULT '',
  `postcode` varchar(10) NOT NULL DEFAULT '',
  `plaats` varchar(50) NOT NULL DEFAULT '',
  `tel1` varchar(20) NOT NULL DEFAULT '',
  `tel2` varchar(20) NOT NULL DEFAULT '',
  `mob` varchar(20) NOT NULL DEFAULT '',
  `user` varchar(16) NOT NULL DEFAULT '',
  `password` varchar(64) NOT NULL DEFAULT '',
  `email` varchar(250) NOT NULL DEFAULT '',
  `supervisor` varchar(1) NOT NULL DEFAULT '0',
  `edinrs_active` enum('0','1') NOT NULL DEFAULT '0',
  `ubnnummer` varchar(20) NOT NULL DEFAULT '',
  `brsnummer` varchar(20) NOT NULL DEFAULT '',
  `vertegenwoordiger` varchar(16) NOT NULL DEFAULT '',
  `edizuivel_active` varchar(1) NOT NULL DEFAULT '0',
  `edicircle_active` varchar(1) NOT NULL DEFAULT '0',
  `melkvee_online_active` varchar(1) NOT NULL DEFAULT '0',
  `varkens_online_active` varchar(1) NOT NULL DEFAULT '0',
  `email_active` varchar(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`user`),
  KEY `naam` (`naam`),
  KEY `password` (`password`),
  KEY `supervisor` (`supervisor`),
  KEY `edinrs_active` (`edinrs_active`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

Sorry for my bad English
Greetings,
Erik van Engelen

Original issue reported on code.google.com by vane280...@gmail.com on 4 Aug 2010 at 4:03

GoogleCodeExporter commented 9 years ago
With types "Enum" and "Set" was error. (Issue 287 <=> Issue 270 <=> Issue 267)

Original comment by viru...@gmail.com on 1 Feb 2011 at 9:29