EF Feature CTP5 Released!

re: EF Feature CTP5 Released!

Lionel — Wed, 02 Mar 2011 10:37:46 GMT

Hi guys,

I have a question regarding type conversion.

Assuming I have a column of type "int" on the DB side and I want to have the corresponding property as a "string" on the entity side. How can I do that using CodeFirst?

I have tried the following statement into my EntityTypeConfiguration class:

Property(st => st.Id).HasColumnType("int"); // st.Id is a "string"

But I get the following error:

System.Data.MetadataException : Schema specified is not valid. Errors:

(7,6) : error 0063: MaxLength facet isn't allowed for properties of type date.

How can I achieve my scenario? Is it possible?

Thx

re: EF Feature CTP5 Released!

Jack — Fri, 18 Feb 2011 00:44:46 GMT

Is there a way to disable alphabetical sorting of columns yet?

re: EF Feature CTP5 Released!

Guest — Wed, 16 Feb 2011 12:34:37 GMT

Help me please create context class for this model:

public abstract class Publication

{

public int Id { get; set; }

public ICollection<CoAuthor> CoAuthors { get; set; }

}

public class JournalArticle : Publication

{

public int Id { get; set; }

public string ArticleName { get; set; }

}

public class CoAuthor

{

public int Id { get; set; }

public int EmployeeId { get; set; }

}

I have:

public class ModelContext : DbContext

{

public DbSet<Publication> Publications { get; set; }

public DbSet<CoAuthor> CoAuthors { get; set; }

protected override void OnModelCreating(ModelBuilder builder)

{

builder.Entity<JournalArticle>().Map(m =>

{

m.MapInheritedProperties();

m.ToTable("JournalArticle", "Science");

});

builder.Entity<CoAuthor>().ToTable("CoAuthor", "Science");

}

But I give error "Schema specified is not valid. Errors: (35,6) : error 0040: Type Publication is not defined in namespace CodeFirstDatabaseSchema (Alias=Self). (64,8) : error 0100: The referenced EntitySet Publication for End Publication could not be found in the containing EntityContainer."

Thank you

re: EF Feature CTP5 Released!

Darius — Fri, 11 Feb 2011 23:54:12 GMT

This is all fantastic. Been using it for a little while. My only feature request is better support for the occasional raw SQL and SP that is needed. Also, I've seen some of the SQL that gets generated and it's not very pretty. I'm assuming those are some of the things among others that will be fixed in the final version. Speaking of, when is it going to be out???? Sooner the better!!

re: EF Feature CTP5 Released!

Brett Styles — Sat, 05 Feb 2011 11:43:47 GMT

There is a major issue with deployment on hosted environment that only allow Medium Trust, the EF produces security exceptions.

re: EF Feature CTP5 Released!

Arjen — Thu, 27 Jan 2011 07:17:36 GMT

I struggle with unit testing and drop&recreation of the database. During execution of my unit tests I always receive the exception : "The model backing the 'bla bla' context has changed since the database was created". Even when I add a connectionstring in app.Config, this exception occurs. I wat to prevent using IDatabaseInitializer in code, since this will end-up in production.

So, bottom line, where should you call an instance of IDatabaseInitializer? In unit testing code or production code? As well, it looks like that CTP5 does not detect the appConfig connectionstring setting (and yes, the name of the setting equals to the classname of the DbContext class)

Thanks in advance

re: EF Feature CTP5 Released!

Yazid — Sun, 23 Jan 2011 22:13:57 GMT

Excellent stuff, a small question. Let us assume I have data that comes from a service and I would like to use EF CTP4 or CTP5 and I have no database and I do not want a database. Can I pass my data to the wrapper. I mean

public class EF4ApplicationPOCOContext : ObjectContext

{

public EF4ApplicationPOCOContext(IServiceLocataor serviceLocator)

{

ContextOptions.LazyLoadingEnabled = true;

ObjectSet<User> obj = new ObjectSet<User>();

obj.AddObject(serviceLocator.GetUser());

// I do the above for all my dataModel

}

private ObjectSet<User> _users;

public ObjectSet<User> Users

{

get

{

return _users;

}

re: EF Feature CTP5 Released!

Norman Mackay — Tue, 18 Jan 2011 09:34:23 GMT

Asked the stored proc caching question on 4 different forums but got no response.

Helped us make up out mind it's not the ORM of choice as you can't get a simple yes or no to features. How are you supposed to plan for future products if you have no idea on the development path is beyond me.

One thing I will say is ignoring stored procs is a mistake, companies aren't going to drop them and re-write them in code for the sake of a new data access layer., the costs of dev alone is prohibitive.

re: EF Feature CTP5 Released!

Andreas Brglez-Hummer — Fri, 14 Jan 2011 09:45:42 GMT

Hi Ado.Net Team

Will there be support for other Databases like Firebird in the near future? I tried to get a code only demo running. After many different not working approaches I have tried to pass a FbConnection (descendant of DbConnection) to my derived DbContext class and ended up with the exception "Unable to determine the provider name for connection of type 'FirebirdSql.Data.FirebirdClient.FbConnection'.".

Is there any way to pass the provider name information to DbContext?

Or are there missing things in the FirebirdClient? I am using Version 2.6 of the FirebirdClient which should support EF 4 but maybe not all the new features of CTP 5?

Best regrads,

Andy

re: EF Feature CTP5 Released!

Greg — Thu, 06 Jan 2011 18:55:03 GMT

Just realized that the new DBContext doesn't support Compiled Queries... This has to make the final release. This is the simplest way to squeeze out decent performance from EF and you took it away! What is the status of this?