Comments by Vikram_ (Top 15 by date)

One thing I don't understand why the datagrid is able to show all records where as these queries unable to find a single row
I even tried adding the following code after the above code:

MessageBox.Show(objctx.registrations.ToList().Count.ToString());

this shows me 0(zero) which is really very strange!

I have added the code in the page but since its in View folder which is not under myproject.web node but under other myproject node(having folders like Assets,Views) so may be breakpoint doesn't work there the way breakpoint in javascript in asp.net

what I did is added a messagebox displaying value and its shows the count 0(zero) for query3 which you provided.

I added your code just below where I bind my datagrid in constructor as:


InitializeComponent();

var objctx = new myDomainContext();
EntityQuery query = objctx.GetRegistrationsQuery();
LoadOperation loadOp = this.objctx.Load(query);
mydatagrid.ItemsSource = loadOp.Entities;

// code provided by you begins below

var query1 = objctx.registrations.ToList();


foreach (registration reg in query1)
{
MessageBox.Show(reg.userid); // Is never called.
}

var query2 = objctx.registrations.Where(i => i.userid == "abc@abc.com");
var query3 = objctx.registrations.Where(i => i.userid == "abc@abc.com").Count();
MessageBox.Show(query3.ToString()); // This shows 0(zero)

I am having another page where I dropped a datagrid and in page constructor after the InitializeComponent();

as

var objctx = new myDomainContext();
EntityQuery<registration> query = objctx.GetRegistrationsQuery();

LoadOperation<registration> loadOp = this.objctx.Load(query);
mydatagrid.ItemsSource = loadOp.Entities;

and that works perfectly fine, showing all records in my database (specifically the entire registration table which is having all those duplicate values)

Hope that is enough to be sure that same database instance is connnected. I also did the modification in the database directly and checked the changes in VS its all as expected reflecting all those changes.

In SQL Management Studio I get those records with provided userid. But in Visual Studio even after hard-coded userid it shows there is no duplicate record found (i.e it returns false in your method provided IsUserIdTaken()) and adds that record in database resulting a duplicate userid in the database.

I tried both ways but don't know why, although I have a user id in my registration table which I again try to enter in the registration page intentionally but in the function returning count it gives the count equal to zero and in the function returning Boolean value it gives false. I even tried to update the .edmx file mapping domainservice.cs, clean solution,rebuilt etc. even tried creating new solution with same thing but still I get 0(zero) or false which means I have no duplicate value in the database but there is a value in the registration table with same id which I try to enter and so the details get saved with duplicate values in the database.

But Toolbox includes only Text Object,Line Object and Box Object. I can't see any table control in toolbox of Visual Studio 2005 IDE

Yeah same logic defining regions for control. But better and efficient option or alternative.

Thanks for help. But sorry, I think you interpreted something different. Actually I knew this aspect. The thing in which I was having problem was the mouse events code for resizing forms. Well anyways this was also a helpful code for regaining titlebar buttons property. Thanks again.

Thanks for the help. I was expecting for the same solution as you provided here for my problem.

Reason for my vote of 5
This was the solution I was seeking for the problem or question I asked.