I'm attempting to create a code-first model to support both Oracle and SQL Server - I have the SQL side working, however with an eval of the devart provider I'm getting the following with Oracle... any ideas what I'm doing wrong?
The server encountered an error processing the request. The exception message is 'Schema specified is not valid. Errors: (8,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (9,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (10,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (11,6) : error 0040: The Type date is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (19,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (20,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (21,6) : error 0040: The Type date is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (28,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (29,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (30,6) : error 0040: The Type blob is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (31,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (32,6) : error 0040: The Type date is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification. (40,6) : error 0040: The Type varchar2 is not qualified with a namespace or alias. Only PrimitiveTypes can be used without qualification.'. See server logs for more details. The exception stack trace is:
at System.Data.Metadata.Edm.StoreItemCollection.Loader.LoadItems(IEnumerable`1 xmlReaders, IEnumerable`1 sourceFilePaths) at System.Data.Metadata.Edm.StoreItemCollection.Init(IEnumerable`1 xmlReaders, IEnumerable`1 filePaths, Boolean throwOnError, DbProviderManifest& providerManifest, DbProviderFactory& providerFactory, String& providerManifestToken, Memoizer`2& cachedCTypeFunction) at System.Data.Metadata.Edm.StoreItemCollection..ctor(IEnumerable`1 xmlReaders) at System.Data.Entity.ModelConfiguration.Edm.Db.DbDatabaseMetadataExtensions.ToStoreItemCollection(DbDatabaseMetadata database, Action`1 storeAction) at System.Data.Entity.ModelConfiguration.Edm.Db.Mapping.DbDatabaseMappingExtensions.ToMetadataWorkspace(DbDatabaseMapping databaseMapping, Action`1 storeAction) at System.Data.Entity.Internal.CodeFirstCachedMetadataWorkspace.GetMetadataWorkspace(DbConnection connection) at System.Data.Entity.Infrastructure.DbModel.CreateObjectContext[TContext](DbConnection existingConnection) at System.Data.Entity.Internal.LazyInternalContext.InitializeContext() at System.Data.Entity.Internal.LazyInternalContext.get_ObjectContext() at AmCom.Services.Model.Meta.TenantModel.op_Implicit(TenantModel ctx) in C:\Users\daves\Documents\Visual Studio 2010\Projects\DataServicesWebApp\AmCom.Services.Model\Meta\TenantModel.cs:line 49 at WcfService1.TenantService.CreateDataSource() in C:\Users\daves\Documents\Visual Studio 2010\Projects\DataServicesWebApp\WcfService1\TenantService.svc.cs:line 41 at System.Data.Services.DataService`1.CreateProvider() at System.Data.Services.DataService`1.HandleRequest() at System.Data.Services.DataService`1.ProcessRequestForMessage(Stream messageBody) at SyncInvokeProcessRequestForMessage(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage31(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)
Search found 1 match
Search found 1 match
• Page 1 of 1
- by stienessen
- Thu 27 Jan 2011 15:12
- Forum: Entity Framework support
- Topic: Code first with CTP5 error??
- Replies: 3
- Views: 2653
Search found 1 match
• Page 1 of 1
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins