Support EF DDL Generation?

Dec 5, 2009 at 2:58 AM

I had try to create an Entity in EF designer in VS2010 beta2,  even i had set the EffiProz provider, it is still generate the normal MSSQLServer 's DDL grammar.

If EffiProz support  this feature, will be perfect :)

Coordinator
Dec 6, 2009 at 6:57 AM

Hi, Thanks for letting us know.

Do you mean  "Generate Database Script from Model... " menu item ? Isn't this feature(Model-First Development) comes with EF4?

Dec 7, 2009 at 4:23 AM

Hi, yes, in EF4, DDL Generation can be handle by custom template. 

We just need to modify the existing template 'SSDLToSQL10.tt' and make another one 'SSDLToEffiproz.tt' to fit the grammar about Effiproz(or HSQLDB?).

Sorry i am not familiar with HSQLDB , but i hope this text template will be support in the future.

About the custom template information:

http://blogs.msdn.com/adonet/archive/2009/11/05/model-first-with-the-entity-framework-4.aspx

Coordinator
Dec 7, 2009 at 7:00 AM

Hi, Thanks. We'll include this with our next release (which will be after few more Silverlight releases).

Dec 14, 2009 at 2:50 AM

does EffiProz support object quotation mark( like [] in  MSSQL or `` in MySQL)?

[] is used to avoid space or keyword in table names or field names in mssql.

Dec 14, 2009 at 7:44 AM
Edited Dec 14, 2009 at 7:45 AM

as unruleboy said, i had write a template for SQLite, and test it for effiproz,  it seems the Grammer had a few difference.

my template is here: http://www.cnblogs.com/timiil/archive/2009/12/12/1622676.html

i  think it is not very difficult to modify to effiproz.

Coordinator
Dec 14, 2009 at 2:44 PM

you can enclose table names, column names, etc. in " (double quote).

Coordinator
Dec 14, 2009 at 11:20 PM

Thanks timiil. I'll include it with the next release.