I keep getting this error:
The Type clob is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.
I have been trying out to use EF 4.1 (code first) with MVC 3, against a legacy Oracle 10g database, using devart dotconnect. The legacy database **cannot** be changed. I'm trying to read the data in it out to a webpage.
(Devart.Data.Oracle Version: 5.70.140.0)
I've had a few errors to overcome along the way, but came to this one.
This is my code:
Web.config connection info:
Code: Select all
Code: Select all
namespace AllInOne
{
public class OdeToTrainingCoursesDB : DbContext
{
public DbSet VENUES { get; set; }
}
}
Code: Select all
using System.ComponentModel.DataAnnotations;
namespace AllInOne.Models
{
public class VENUES
{
[Key]
public int VENUE_ID { get; set; }
}
}
Code: Select all
CREATE TABLE VENUES
(
VENUE_ID NUMBER(10) NOT NULL,
VENUE_TYP VARCHAR2(1 BYTE),
BASE_ORG NUMBER(10) NOT NULL,
COUNTY VARCHAR2(35 BYTE)
)