Dear you have to make a table for mapping with Sp, i.e. if your sp is returning 5 columns record set then you have to make a table with 5 columns and proper data types. Then you can call this code as proper Object Type List. so *DTO.* *TemplateTypeStyleSizePrice* **this is a table name that sp is returning me in the form of record set or data set.
On Wed, Jun 2, 2010 at 12:01 PM, Nikunj Prajapati <[email protected]>wrote: > Hi Niyaz , > > Thanks for your reply. > I have some doubt. > > I have a datacontext class with namespace "temp" using dblinq > > when i am trying to create a list object into my class file like > > > public List<*temp.NewTest*> GetDetails() > { > } > > in this syntax i am unable to get details of Stored Procedures list. > I am only getting a list of tables / views. > > and after that i am unable to create a object like > * > List<temp.NewTest> table = null; > > > like your object > > List<DTO.* > *TemplateTypeStyleSizePrice> table = null;* > > . > > In this code > > > NewTest is my stored procedure name. > > And also i am not getting CreateFactory method in my class file. > > > > So can you please explain me this thing in detail. if you need some more > details then let me know. > > Thanks & Regards, > Nik. > > > > > On Tue, Jun 1, 2010 at 10:30 PM, Muhammad Niyaz Rana > <[email protected]>wrote: > >> Dear Nik, >> Here is the sample code to call sp: >> >> public static List<DTO.TemplateTypeStyleSizePrice> Get(long >> templateTypeId, long? templateStyleId) >> { >> List<DTO.TemplateTypeStyleSizePrice> table = null; >> DTO.SmallPrintProContext dataContext = >> DAL.ContextFactory.Create(); >> * table = >> dataContext.ExecuteQuery<DTO.TemplateTypeStyleSizePrice>(String.Format("call >> SelectTemplateTypeStyleSizePrice({0},{1})", templateTypeId, >> templateStyleId)).ToList();* >> >> return table; >> } >> >> if you have any concerns please let me know. >> Best Regards, >> >> On Wed, Jun 2, 2010 at 8:17 AM, Nik <[email protected]> wrote: >> >>> Hi, >>> >>> Can any body give me a sample example of calling stored procedure from >>> DB Linq for mysql database. I am using DBLinq 0.20 version. >>> >>> Thanks & Regards, >>> Nik. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups >>> "DbLinq" group. >>> To post to this group, send email to [email protected]. >>> To unsubscribe from this group, send email to >>> [email protected]<dblinq%[email protected]> >>> . >>> For more options, visit this group at >>> http://groups.google.com/group/dblinq?hl=en. >>> >>> >> >> >> -- >> Best Regards, >> Muhammad Niaz >> Sr. Software Engineer >> BITLogix (Pvt) Limited >> >> www.ebitlogix.com | ( +9242 3577 4941-3 ) | +92 321 569 4195 | >> [email protected] >> 702 Al-Hafeez Shopping Mall, >> Main Boulevard Gulberg, Lahore >> >> -- >> You received this message because you are subscribed to the Google Groups >> "DbLinq" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<dblinq%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/dblinq?hl=en. >> > > > > -- > Thanks & Regards, > Nikunj Prajapati. > > -- > You received this message because you are subscribed to the Google Groups > "DbLinq" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<dblinq%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/dblinq?hl=en. > -- Best Regards, Muhammad Niaz Sr. Software Engineer BITLogix (Pvt) Limited www.ebitlogix.com | ( +9242 3577 4941-3 ) | +92 321 569 4195 | [email protected] 702 Al-Hafeez Shopping Mall, Main Boulevard Gulberg, Lahore -- You received this message because you are subscribed to the Google Groups "DbLinq" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/dblinq?hl=en.
