Home
Help
Register
Log in

Search

 
   Active Threads  

You are here: Home > LLBLGen Pro > General> Could we use simple SQL in LLBLGen?
 

Pages: 1
General
Could we use simple SQL in LLBLGen?
Page:1/1 

  Print all messages in this thread  
Poster Message
nevernet
User



Location:

Joined on:
01-Feb-2010 13:21:09
Posted:
67 posts
# Posted on: 05-Oct-2011 05:08:46.  
Hello

for example, the simple query sql is : select a,b,c from table.

some method like this:

DataTable dt = dao.ExecuteSQLAsDataTable(sql);

is there such way in LLbgen pro?

THank you
Dev Environment as below:
.Net 3.5, LLBLGen Pro 2.6, SQLServer 2008, IIS7
 
Top
daelmo
Support Team



Location:
Guatemala City
Joined on:
28-Nov-2005 23:35:24
Posted:
7625 posts
# Posted on: 05-Oct-2011 05:40:07.  
Hi nevernet,

We encourage people to not execute raw queries unless is really necessary. If the tables you are interested where mapped your LLBLGen project then you could use a Entity Fetch, or if you wan to make joins and combine the final projection with multiple entities you can use TypedViews, TypedViews or DynamicList.

If you still to execute a retrieval raw sql you can use a RetrievalQuery. Please check these related threads:
http://www.llblgen.com/TinyForum/Messages.aspx?ThreadID=9173&StartAtMessage=0&#51050
http://llblgen.com/tinyforum/Messages.aspx?ThreadID=12293&StartAtMessage=0&#68261


David Elizondo
LLBLGen'ing (articles and code snippets) | linkedin | twitter
 
Top
nevernet
User



Location:

Joined on:
01-Feb-2010 13:21:09
Posted:
67 posts
# Posted on: 05-Oct-2011 07:51:18.  
Hi, Daelmo

Thanks for you reply, i know its rules, in this case it's special thing.
Dev Environment as below:
.Net 3.5, LLBLGen Pro 2.6, SQLServer 2008, IIS7
 
Top
Pages: 1  


Powered by HnD ©2002-2007 Solutions Design
HnD uses LLBLGen Pro

Version: 2.1.12172008 Final.