In v3.1, is there a command line tool that will allow me to auto map all of my defined entities into SQL Server 2008 targets? I don't want to have to open the designer to do this.

Sorry -no. We have the command line refresher ported to 3.1 but it will only refresh already mapped entities.

How many entities do you have ?

Matt

Just use the designer, it's a 10 seconds action, tops. Right-click 'SQL Server (SQLClient)' in catalog explorer' -> reverse engineer tables to entity definitions -> check all -> go.

I am trying to write a tool that can use .net reflection to read a set of .net classes that are part of a data model and produce a properly formatted llblgen project file that includes entity definitions and fields. The requirement is to not have to open the designer at all during the whole process. The only step that is missing is the auto mapping, which is not available via a command line.

And what are you going to do with the file, if I may ask? At one point you have to load it into the designer to do things... Or do you use the command line code generator? The problem is that if something is not valid, or the automapper can't create a field for example because a type needs a type converter or other, it is a problem you can't solve in code, you need the designer for that.

Btw, v3.1 has an import system. You could create a simple importer (see the sourcecode in the sdk) to import the entities from the assembly and go from there.

Even if I write an importer, is still sounds like the importing must be initiated by the llblgen designer. Is that correct?

vivacee wrote:

Even if I write an importer, is still sounds like the importing must be initiated by the llblgen designer. Is that correct?

yes.

The upside is that you get the validation and correction facilities inside the designer as well. Don't really see the advantage of doing it outside the designer... sooner or later you'll have to open the file in the designer, export DDL SQL etc. anyway.