Pass Class to Generic Method Which Execute Stored Procedure

Asked Sep 07 '14 at 07:00

Active Sep 07 '14 at 08:13

Viewed 372 times

Here is my database structure:

enter image description here

I am using Linq-to-SQL, here is my class structure.

 DataBaseClassDataContext context = new DataBaseClassDataContext();
 GenericMethod gm = new GenericMethod();
 var student= gm.GetData<info>(1);
 var info = gm.GetData<Student>(2);
 Console.ReadLine();

Here is my GenericMethod class:

DataBaseClassDataContext context = new DataBaseClassDataContext();

public List<T> GetData<T>(int classcode) 
{
    if (classcode == 1)
    {
         return context.InfoSelect().Cast<T>().ToList<T>();
    }
    else
    {
        return context.StudentSelect().Cast<T>().ToList<T>();
    }
}

I want to pass class to my generic method, which further run stored procedure and give back me list of that class. How can I do that? I get an error

Unable to cast object of type 'GenericMethods.StudentSelectResult' to type 'GenericMethods.Student'.

Kindly guide me, what am I missing?

edited Sep 07 '14 at 08:13

marc_s

732,580
175
1,330
1,459

asked Sep 07 '14 at 07:00

Muhammad Ali

http://stackoverflow.com/questions/899629/cast-object-to-t - does it help? – Konstantin Chernov Sep 07 '14 at 07:06
@KokaChernov..I insert following line `return (T)Convert.ChangeType(context.StudentSelect().Cast().ToList(), typeof(T));`,it gives error Cannot implicitly convert type 'T' to 'System.Collections.Generic.List' – Muhammad Ali Sep 07 '14 at 07:15
2

Run this: var type= context.StudentSelect().First().GetType(); Tell us what "type" is. – George Vovos Sep 07 '14 at 07:55
Or try smth like `(T)Convert.ChangeType(context.StudentSelect().First(), typeof(T));` – Konstantin Chernov Sep 07 '14 at 07:57
@GeorgeVovos...now type contains a number of properties...tell me what exactly you want from these properties – Muhammad Ali Sep 07 '14 at 08:04
@KokaChernov..same error – Muhammad Ali Sep 07 '14 at 08:05
@MuhammadAli type.FullName – George Vovos Sep 07 '14 at 08:06
type.FullName =GenericMethods.StudentSelectResult – Muhammad Ali Sep 07 '14 at 08:08
by changing this line `var student= gm.GetData(1);`,i got result...:) – Muhammad Ali Sep 07 '14 at 08:14
@MuhammadAli you've got the result of the other type, not `Student`? – Konstantin Chernov Sep 07 '14 at 08:43
@KokaChernov..it is the sp class in .dbml class,that returns me the sp result – Muhammad Ali Sep 07 '14 at 10:21

Pass Class to Generic Method Which Execute Stored Procedure

0 Answers0