Ideas for designer

Hi,

I very much like the model first approach. And the synchro feature of the designer.

But I don't like to get to SQL Management studio to define further views, indices and stored procedures to the DB which was born in the Lightspeed.

Is there any plan to extend the designer to the full blown database designer tool? 

Maybe it could be done for the major DB players like MS SQL and Oracle.

For example it would be very usefull if we can forge some .NET stored procedures in designer for MS SQL. That would be an end to end database design experience.

Hi CodeWizards,

We're not planning a database design product at the moment -- even if we consider just SQL Server and Oracle, they have so many options that it would take a significant investment to produce a tool that satisfied people who wanted fine control over their databases.  We have tossed the idea around though, and we'll continue to listen for feedback on this!

As I today playing with the designer because getting rid of Value Objects and restructuring the whole stuff, getting another idea which would greatly speed up checking the Entities.

1. Detail view. Like in MSSQL designer, it would be nice it we can opt for entity detail view, wher we can see in the diagram the Type of the Property and it is Nullable or not.  Because the designer don't support (yet) the CreatedBy, UpdatedBy, DeletedBy fields so we need to add them all Entities which need to be audited.  There is some degree of error when i type "string? DeletedBy". Sometimes just missing the "?" char. And the database is complaining about inserting NULL values into DeletedBy field when i create the Entity.

2. Alternatively cen we just get some other icons which can be depicting that the given property is Nullable.

Regards

Sandor

You can have LightSpeed show the type against each property via Tools > Options > LightSpeed; this includes whether the type is nullable.

Thanks for the suggestion on checking the audit info field types -- there might be some compatibility implications but we'll certainly take a look!

Thanks for the headups.

But I can only see the type the Nullable status is not shown in the Entity shape.

Regards

Sandor

Hmm, it should be shown as part of the type e.g. int? SomeInt.

I think the question mark might not be shown for strings and other reference types as it is the CLR type not the database type -- perhaps that's the problem?

I tried for single, double, int, string, char types all of them Nullabe but no question mark shown.

I defined them with keyboard typing for example "int? IntegerType". The result was "Int32 IntegerType" no question mark.

Regards

Sandor 

Thanks Sandor.  I'll check this out and we'll try to get it sorted for you.

Thanks for alerting us to this.  The question mark will be displayed beginning with the next nightly build (available from about 1200 UTC).

Thanks Ivan!

Best support ever!

Hi,

Ivan I downloaded the last nightly (from 09/28) and installed over the former last one.

Don't saw any change. There are'nt any question marks in the entity shape.

So I uninstalled completly the lightspeed, double checked the find any stalling mindscape assemblies. Not found any.

Reinstalled the last nightly. 

Nothing changed. 

What can be a problem? 

How can I help to hunt down the bug?

Regards

Sandor

You need the 29 September nightly, not 28 September.  Perhaps our automatic uploader was running an hour or two slow!  In any case, it is up now -- let us know if you still have no joy.

Yep,

Everything is working now. Maybe the problem is the Timezone difference. I am living in Hungary in the GMT+2 zone. When I downloaded the nightly it was 10AM local time 29th of Sep. When I typing this it almost midnight 29th. 

So maybe I simply was too fast to download the nightly. 

Regards

Sandor