Solved

Delete All

Posted on 2012-03-26
7
271 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
  • 4
  • 3
7 Comments
 
LVL 15

Assisted Solution

by:angus_young_acdc
angus_young_acdc earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Hi! I tried this lo.Entities.All(); but it doesn't work! Can you provide me how to change the query?
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 15

Expert Comment

by:angus_young_acdc
Comment Utility
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
Comment Utility
Hi! I'm trying but it does'nt work...
0
 

Accepted Solution

by:
Whing Dela Cruz earned 0 total points
Comment Utility
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
Comment Utility
Thanks!
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction This article series is supposed to shed some light on the use of IDisposable and objects that inherit from it. In essence, a more apt title for this article would be: using (IDisposable) {}. I’m just not sure how many people would ge…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

763 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now