Hello everyone, as I'm doing an academic project. I'm stuck to another problem. I'm maintaining records of some files in the database table, I need some help(rather a code) to delete files physically who doesn't have ay records in any table.... kindly help me out...

Hi there,

You have a few options. For example you could:

Get your file names / path from the database (using ADO.NET, LINQ to SQL, Entity Framework or some other data access method) and then loop over the file names and use System.IO.File.Exists to see if the file exists.

Alternatively, you can take a look here: http://imar.spaanjaars.com/424/fun-with-linq Warning: DON'T use this with many files as the performance is bad. Just see it as a fun (ab)use of LINQ to SQL.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!