Click here to Skip to main content
15,896,063 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi. i can not view database records.
i have a database (appuser), i create in code a new user and insert it there.
when i try to find a user with an email by using this code:
C#
AppDatabaseDataContext db = new AppDatabaseDataContext();
                return (from rows in db.AppUser
                        where rows.Email.Trim().ToLower() == email.Trim().ToLower()
                        select rows).FirstOrDefault();

it returns a user with specified email.
when i open my database in visual studio, there are no records in it.
when i try to add a new record via visual studio and then call
SQL
select * from appuser

it returns only record, that i have created via visual studio (database wizard)
any ideas how to fix this?
Posted
Comments
Sascha Lefèvre 29-Mar-15 18:02pm    
Sounds like you're not committing the transaction.
ZurdoDev 30-Mar-15 9:00am    
Sounds like you may be pointing to a different database.

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



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900