Support EF DDL Generation?

Dec 5, 2009 at 3: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 :)

Dec 6, 2009 at 7: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 5:23 AM

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

We just need to modify the existing template '' and make another one '' 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:

Dec 7, 2009 at 8:00 AM

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

Dec 14, 2009 at 3: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 8:44 AM
Edited Dec 14, 2009 at 8: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:

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

Dec 14, 2009 at 3:44 PM

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

Dec 15, 2009 at 12:20 AM

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