Solved

Delete All

Posted on 2012-03-26
7
278 Views
Last Modified: 2012-04-05
How to delete all data in sql in one click?
This is most likely related with my pending question which is now still searching for the solution. The XAML.cs here are as follows

StudentDomainContext objctx;

private void btndelete_Click(object sender, RoutedEventArgs e)
{
objctx = new StudentDomainContext();
var query = objctx.GetStudentsQuery();
objctx.Load(query, Datadelete, null);
}

private void Datadelete(LoadOperation<student> lo)
{
student st = lo.Entities.First();
objctx.student.Remove(st);
try
{
objctx.SubmitChanges();
MessageBox.Show("Data deleted!")
}
catch (Exception ex)
{
MessageBox.Show("Data deletion failed" +ex.Message);
}

}

The Class query are as follos......
public IQueryable<student> GetStudents()
{
return this.ObjectContext.students;
}

The codes are working but when I execute, only one data will be deleted. What I want here is to delete all datas inside my database concerning student Table. Please Help!
0
Comment
Question by:Whing Dela Cruz
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
7 Comments
 
LVL 15

Assisted Solution

by:angus_young_acdc
angus_young_acdc earned 500 total points
ID: 37765245
It is because you are only selecting the first value on this line: student st = lo.Entities.First();

Try changing it to lo.Entities.All();
0
 
LVL 15

Expert Comment

by:angus_young_acdc
ID: 37765249
Or change the query to DELETE FROM [YourStudentTableName]

If there is no Where clause then it will delete everything in that table.
0
 

Author Comment

by:Whing Dela Cruz
ID: 37765317
Hi! I tried this lo.Entities.All(); but it doesn't work! Can you provide me how to change the query?
0
Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

 
LVL 15

Expert Comment

by:angus_young_acdc
ID: 37765321
var query = objctx.GetStudentsQuery();


The above line should be returning your query (from what I can work out from the amount of code), within the GetStudentsQuery method you should see what is happening and be able to update it accordingly.
0
 

Author Comment

by:Whing Dela Cruz
ID: 37766572
Hi! I'm trying but it does'nt work...
0
 

Accepted Solution

by:
Whing Dela Cruz earned 0 total points
ID: 37769624
Hi! Everyone, What I did here is to put something Loop... But I dought if it is good I dea because I feel that there's something delay of the Looping. Any Idea Please....

private void Datadelete(LoadOperation<student> lo)
{
foreach (student st in lo.Entities)
objctx.student.Remove(st);
try
{
objctx.SubmitChanges();
MessageBox.Show("Data deleted!")
}
catch (Exception ex)
{
MessageBox.Show("Data deletion failed" +ex.Message);
}

}

 Please tell me if there is another solution aside from this....
0
 

Author Closing Comment

by:Whing Dela Cruz
ID: 37810117
Thanks!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article introduced a TextBox that supports transparent background.   Introduction TextBox is the most widely used control component in GUI design. Most GUI controls do not support transparent background and more or less do not have the…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question