Hi,

I am exploring this tool. I want to know how can i generate Sps and complex queries using this tool.

Essentially your question reads as "how do I use your product?".

I would recommend downloading the demo, reading the help docs and experimenting with the Northwind or AdventureWorks database.

I might be wrong, but I don't think LL creates stored procs for you. It can be used for complex queries, but how you do this depends in part if you are using self-serving or adapter. Previous poster is right, there's tons of information in the help guide to explain how to do this in either self-serving or adapter mode.

Is there a specific query you are trying to express through LL?

LLBLGen Pro generate classes that map to your database tables and views, so you can use instances of those classes to read records from database tables and views, either reading one record, multiple records using some filtering criterea (which might be too complex) or reading all the recods, also you can insert new records, update existing records or delete some records. LLBLGen Pro also generate methods that wrap calls to existing stored procedures in the database.

As have been said before there are a lot of information and examples in the docs. Also if you have some query in mind, post it here so we can help you to perform it using LLBLGen Pro.