I am given the job of generating DAL for our project. Our project enviornment is as follows:

1) It is mainly a document management system to be built on WPF + Oracle platform. 2) It will use xmlType to store the XAML template in DB. 3) Also we need to store other documents like word,excel,pdf inside the database. 4) Our Database has max of 40 tables as of now. 5) We are using Enterprise Architect tool for UML data modelling.

6)We need to support fulltext search on xmltype field and binary/text filed.

My questions are:

1) Is LLBLGen is need for above environment? if used what benifits it will offer us in the above environment? 2) Is fulltext search with oracle is supported? 3) Do you have any sample for this kind of envioronment? 4) can we reused the model generated by EA with LLBLgen?

1- Is LLBLGen is need for above environment?

Do you mean: Do you need LLBLGen?

saravana wrote:

I am given the job of generating DAL for our project. Our project enviornment is as follows:

1) It is mainly a document management system to be built on WPF + Oracle platform. 2) It will use xmlType to store the XAML template in DB. 3) Also we need to store other documents like word,excel,pdf inside the database. 4) Our Database has max of 40 tables as of now. 5) We are using Enterprise Architect tool for UML data modelling.

6)We need to support fulltext search on xmltype field and binary/text filed.

My questions are:

1) Is LLBLGen is need for above environment? if used what benifits it will offer us in the above environment? 2) Is fulltext search with oracle is supported? 3) Do you have any sample for this kind of envioronment? 4) can we reused the model generated by EA with LLBLgen?

2) in Linq through a function mapping. Example is for sqlserver, but it can also be used to map CONTAINS(...) > 0 which you'd use for oracle. This is a feature of our own framework btw. If you choose to use nhibernate, it's different (and you've to wait till v3 of nhibernate, as currently functionmappings dont work in nh) and for EF it is possible but EF doesn't support oracle (only through commercial 3rd party providers, which we don't support). NHibernate does have the ability to specify query fragments directly, so you could define the CONTAINS queries. 3) it's not different than any other entity system. documents are stored binary, in BLOB fields, and you can fetch them directly into entities. 4) not directly and it depends on your chosen target framework (NHibernate, our own etc.). Our own framework doesn't support poco classes, so if you design them in enterprise architect, they wont be useful. You can design the poco classes for nhibernate for example by using the the POCO persistence only preset for nhibernate, use nhibernate as target framework and generate code. LLBLGen Pro will emit mappings, session helper class and a html doc which defines the types for the classes. In EA you design these classes this way. So it's not ideal, if you want to work from EA only.

Walaa wrote:

1- Is LLBLGen is need for above environment?

Do you mean: Do you need LLBLGen?

yes.As number of tables are going to be less(max of 40) whether LLBLgen will give any advantages over any other free alternative say Database Application blocks,etc..

Otis wrote:

saravana wrote:

I am given the job of generating DAL for our project. Our project enviornment is as follows:

1) It is mainly a document management system to be built on WPF + Oracle platform. 2) It will use xmlType to store the XAML template in DB. 3) Also we need to store other documents like word,excel,pdf inside the database. 4) Our Database has max of 40 tables as of now. 5) We are using Enterprise Architect tool for UML data modelling.

6)We need to support fulltext search on xmltype field and binary/text filed.

My questions are:

1) Is LLBLGen is need for above environment? if used what benifits it will offer us in the above environment? 2) Is fulltext search with oracle is supported? 3) Do you have any sample for this kind of envioronment? 4) can we reused the model generated by EA with LLBLgen?

2) in Linq through a function mapping. Example is for sqlserver, but it can also be used to map CONTAINS(...) > 0 which you'd use for oracle. This is a feature of our own framework btw. If you choose to use nhibernate, it's different (and you've to wait till v3 of nhibernate, as currently functionmappings dont work in nh) and for EF it is possible but EF doesn't support oracle (only through commercial 3rd party providers, which we don't support). NHibernate does have the ability to specify query fragments directly, so you could define the CONTAINS queries. 3) it's not different than any other entity system. documents are stored binary, in BLOB fields, and you can fetch them directly into entities. 4) not directly and it depends on your chosen target framework (NHibernate, our own etc.). Our own framework doesn't support poco classes, so if you design them in enterprise architect, they wont be useful. You can design the poco classes for nhibernate for example by using the the POCO persistence only preset for nhibernate, use nhibernate as target framework and generate code. LLBLGen Pro will emit mappings, session helper class and a html doc which defines the types for the classes. In EA you design these classes this way. So it's not ideal, if you want to work from EA only.

I didn't understand the answer for my question number 2. With the project requirements above (with Fulltext serach and xmltype data manipulation is mandatory in oracle),shall I go for LLBLgen. If yes,Please provide your approach/suggestion for generating DAL(from model) and BL layer for my project.

Exactly what about the answer to number 2 is unclear - can you be more specific about what you don't understand ?

If you are asking us if you should use LLBLGen, then unsurprisingly the answer is Yes, of course you should...! There are a few (very specific) circumstances when LLBLGen is not the best solution to use, but yours is not one of them - it should fit your needs admirably.

Matt