Search found 2919 matches

by AndreyR
Thu 14 Jul 2011 12:59
Forum: Entity Framework support
Topic: EF Code First - The Type clob is not qualified with a namesp
Replies: 2
Views: 5833

This particular problem can be solved by removing ColumnTypeCasingConvention:

Code: Select all

modelBuilder.Conventions.Remove();
However, I recommend you to refer to our Code First article, it contains a number of useful recommendations.
Here is the code I used to get the values from your table:

Code: Select all

  class Program {
    static void Main(string[] args) {

      OracleEntityProviderConfig config = OracleEntityProviderConfig.Instance;
      config.Workarounds.IgnoreSchemaName = true;
      using(var context = new OdeToTrainingCoursesDB()){
        var q = context.VENUES.ToList();
      }
    }
  }

  public class OdeToTrainingCoursesDB : DbContext { 
    public DbSet VENUES { get; set; }

    protected override void OnModelCreating(DbModelBuilder modelBuilder) {

      modelBuilder.Conventions.Remove();
      base.OnModelCreating(modelBuilder);
    }
  }

  public class VENUES {
    [Key]
    public int VENUE_ID { get; set; }
    public string VENUE_TYP { get; set; }
    public int BASE_ORG { get; set; }
    public string COUNTY { get; set; }
  }
You can try to use the DbContext template, it is designed for generating the Code First-like code for the legacy databases.
However, the current version contains an error. I have sent a working template to the e-mail address provided in your forum profile.
by AndreyR
Thu 14 Jul 2011 11:49
Forum: Entity Developer
Topic: Identity Guid Properties
Replies: 10
Views: 2468

We are investigating the possibility to change this behaviour.
We will let you know about the results of our investigation.
by AndreyR
Thu 14 Jul 2011 10:26
Forum: dotConnect for MySQL
Topic: Error in mapping
Replies: 3
Views: 1233

There is no problem with the long constraint names, I have checked this.
Could you please provide us the call stack of the exception?
Here are the steps:
- Open 2 instances of Visual Studio.
- In the first instance, open the project in which you wish to add the model.
- In the second instance, go to Tools->Attach to process...
- Select the first instance of Visual Studio(devenv.exe with an opened project) in the process list.
- Go to Debug->Exceptions and check the Common Language Runtime Exceptions checkbox.
- Ensure that the Enable Just My Code checkbox (Tools->Options->Debugging) is unchecked.
- Perform the steps to get the error in the first instance of Visual Studio.
If the error was catched, please provide us the type of the exception and the call stack.
by AndreyR
Thu 14 Jul 2011 08:45
Forum: dotConnect for Oracle
Topic: no mapping between entity set and association set
Replies: 2
Views: 1058

Thank you for sharing the solution.
by AndreyR
Wed 13 Jul 2011 14:37
Forum: Entity Developer
Topic: Why should I use Entity Developer over VS 2010 Builtin tool?
Replies: 6
Views: 1922

Charlie, I have sent the document to your e-mail as well. I'd recommend you to delete the email address in order to prevent the spam attacks.
by AndreyR
Wed 13 Jul 2011 12:59
Forum: Entity Developer
Topic: Using ODBC with Entity Developer
Replies: 9
Views: 2872

Yes, Devart Entity models provide support only for dotConnect for Oracle/PostgreSQL/MySQL/SQLite, and Microsoft EF Provider for SQL Server.
Devart LinqConnect models support dotConnects only, and the Devart LINQ to SQL model works only with Microsoft SQL Server.
by AndreyR
Wed 13 Jul 2011 10:32
Forum: Entity Developer
Topic: Why should I use Entity Developer over VS 2010 Builtin tool?
Replies: 6
Views: 1922

I have sent the document to the e-mail address provided in your forum profile. Please let me know if anything goes wrong.
by AndreyR
Wed 13 Jul 2011 08:51
Forum: dotConnect for Oracle
Topic: No views on the EDMX design surface after Update Model
Replies: 1
Views: 963

I have replied to you in this thread.
by AndreyR
Wed 13 Jul 2011 08:50
Forum: dotConnect for Oracle
Topic: Cannot Add Views or Stored Procedure to the Model
Replies: 5
Views: 1183

CaptinTripps, generally, the view should contain some not null columns. However, there are no specific rules that guarantee that the view will definitely be added. Entity Data Model Wizard seeks for the Primary Key first, and if it doesn't find any, it attempts to infer the Entity Key from not null columns.
by AndreyR
Wed 13 Jul 2011 08:19
Forum: dotConnect for PostgreSQL
Topic: Adding function return Composite Type in Devart Entity Model
Replies: 4
Views: 2296

Plazmdk, thank you for sharing the solution.
by AndreyR
Tue 12 Jul 2011 12:58
Forum: Entity Developer
Topic: Using ODBC with Entity Developer
Replies: 9
Views: 2872

You are correct about dotConnect Universal and ODBC support.
However, dotConnect Universal does not contain the Entity Framework (and LinqConnect) support, and Entity Developer does not provide support for dotConnect Universal as well.
by AndreyR
Tue 12 Jul 2011 11:48
Forum: Entity Developer
Topic: Using ODBC with Entity Developer
Replies: 9
Views: 2872

We are not working with ODBC in our Entity Framework support.
Sorry for the inconvenience.
by AndreyR
Tue 12 Jul 2011 10:07
Forum: dotConnect for PostgreSQL
Topic: Multiple connection strings?
Replies: 3
Views: 1359

Take a look at the example in the ObjectContext constructor article.
More details concerning Entity Framework connections can be found in this MSDN article, for example.
by AndreyR
Mon 11 Jul 2011 16:40
Forum: Entity Developer
Topic: Why should I use Entity Developer over VS 2010 Builtin tool?
Replies: 6
Views: 1922

We plan to release an article about Entity Developer and EDM Designer comparison soon.
I will send a draft of such article tomorrow to the e-mail address you provided in your profile.
by AndreyR
Mon 11 Jul 2011 15:58
Forum: Entity Developer
Topic: Cannot access the .edps file as it is used by another proces
Replies: 24
Views: 8552

Thank you for your help, I have reproduced this issue as well.
I will let you know as soon as it is fixed.