Entity Framework problem storing data in session

Question

0.00/5 (No votes)

See more:

I am using entity framework problem in getting data in session.

C#

var res = from a in ef.Logins where a.username == txtuser.Text && a.password == txtpass.Text select a.login_id;
Session["rcode"]=res;

if(Session["rcode"]!=null)
{
Abc obj=(Abc)Session["rcode"];
lable.text=obj.loginid;/// con not show data in lable
}

Error message is:

C#

System.Data.Objects.ObjectQuery`1[System.String]

Posted 11-Dec-13 19:11pm

awaisshabir

Updated 12-Dec-13 9:35am

RaisKazi

v2

Add a Solution

Comments

[no name] 12-Dec-13 3:46am

from where your exception occured ? Please mention.
if it is from lable.text=obj.loginid; line,
then call obj.loginid.toString();

JoCodes 12-Dec-13 23:59pm

In which line exactly the error occurred?. I dont think its related to your session storage rather its related to your linq query.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

JoCodes · Answer 1 · 2013-12-12T18:22:00

Try something like

var res = from a in ef.Logins where a.username == txtuser.Text && a.password == txtpass.Text select a.login_id;
string loginID= res.SingleOrDefault();

//expecting a.login_id is string Datatype.

Then assign the value to Session and access accordingly.

Hope this helps you

The14thNoah · Answer 2 · 2013-12-12T16:53:00

Solution 1

have you tried this
Session["rcode"]=res.ToString();

Posted 12-Dec-13 16:53pm

The14thNoah

sankarsan parida · Answer 3 · 2013-12-12T18:47:00

See we can modify it in different ways
IF you need login id then by the data type "select a.login_id"

XML

<pre lang="cs">
int res =Convert.ToInt32( from a in ef.Logins where a.username == txtuser.Text && a.password == txtpass.Text select a.login_id);
Session["rcode"]=res;

if(Session[&quot;rcode&quot;]!=null)
{ 
lable.text=Session["rcode"].ToString(); 
}</pre>

Then If you need to keep whole login class in Session
Code below

Login res = (from a in ef.Logins where a.username == txtuser.Text && a.password == txtpass.Text select a).FirstOrDefault();
Session["rcode"]=res;
 
if(Session["rcode"]!=null)
{
Login obj=(Login )Session["rcode"];
lable.text=obj.loginid;/// con not show data in lable
}

Entity Framework problem storing data in session

3 solutions

Solution 2

Solution 1

Solution 3

Add your solution here

Preview 0