I am here on skype: MuhammadNiaz if you have any concerns please let me know via Call best regards.
On Wed, Jun 2, 2010 at 12:10 PM, Muhammad Niyaz Rana <[email protected]>wrote: > 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 > -- 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.
