Ttykuu

Is openssl rand command cryptographically secure?

How would you say "es muy psicólogo"?

Why do early math courses focus on the cross sections of a cone and not on other 3D objects?

Why datecode is SO IMPORTANT to chip manufacturers?

How does light 'choose' between wave and particle behaviour?

What are the main differences between Stargate SG-1 cuts?

Sally's older brother

Google .dev domain strangely redirects to https

Why is std::move not [[nodiscard]] in C++20?

Printing attributes of selection in ArcPy?

Special flights

What is the origin of 落第?

Is multiple magic items in one inherently imbalanced?

Did Mueller's report provide an evidentiary basis for the claim of Russian govt election interference via social media?

How to ternary Plot3D a function

What does 丫 mean? 丫是什么意思？

How much damage would a cupful of neutron star matter do to the Earth?

What does Turing mean by this statement?

Is there hard evidence that the grant peer review system performs significantly better than random?

How to force a browser when connecting to a specific domain to be https only using only the client machine?

My mentor says to set image to Fine instead of RAW — how is this different from JPG?

Getting out of while loop on console

Why weren't discrete x86 CPUs ever used in game hardware?

A term for a woman complaining about things/begging in a cute/childish way

LINQ or Lambda for two foreach query

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;

0

$begingroup$

The code I have written works fine, this inquiry being purely for educational purposes. I want to know how others would do this better and cleaner. I especially hate the way I use two for loops to get data. There has to be a more efficient way.

I have got a Document Name Table in my SQL database and Files in Content Folder.
I have got a Two list- ListOfFileNamesSavedInTheDB and ListOfFileNamesInTheFolder.

Basically, I am getting all file names saved in Database and checking is it exist in the Folder, if not delete file name from the database.

 var clientDocList = documentRepository.Documents.Where(c => c.ClientID == clientID).ToList();

 if (Directory.Exists(directoryPath))
 
 string[] fileList = Directory.GetFiles(directoryPath).Select(Path.GetFileName).ToArray();
 bool fileNotExist = false;
 foreach (var file in fileList)
 
 foreach(var clientDoc in clientDocList)
 
 if (clientDoc.DocFileName.Trim().ToUpper()==file.ToUpper().Trim())
 
 fileNotExist = false;
 break;
 
 

 if (fileNotExist)
 
 //Delete file name from Database
 
 
 

c# linq

share

asked 2 mins ago

AliAzraAliAzra

11

New contributor

AliAzra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$endgroup$

add a comment | 

0

$begingroup$

The code I have written works fine, this inquiry being purely for educational purposes. I want to know how others would do this better and cleaner. I especially hate the way I use two for loops to get data. There has to be a more efficient way.

I have got a Document Name Table in my SQL database and Files in Content Folder.
I have got a Two list- ListOfFileNamesSavedInTheDB and ListOfFileNamesInTheFolder.

Basically, I am getting all file names saved in Database and checking is it exist in the Folder, if not delete file name from the database.

 var clientDocList = documentRepository.Documents.Where(c => c.ClientID == clientID).ToList();

 if (Directory.Exists(directoryPath))
 
 string[] fileList = Directory.GetFiles(directoryPath).Select(Path.GetFileName).ToArray();
 bool fileNotExist = false;
 foreach (var file in fileList)
 
 foreach(var clientDoc in clientDocList)
 
 if (clientDoc.DocFileName.Trim().ToUpper()==file.ToUpper().Trim())
 
 fileNotExist = false;
 break;
 
 

 if (fileNotExist)
 
 //Delete file name from Database
 
 
 

c# linq

share

asked 2 mins ago

AliAzraAliAzra

11

New contributor

AliAzra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$endgroup$

add a comment | 

$begingroup$

The code I have written works fine, this inquiry being purely for educational purposes. I want to know how others would do this better and cleaner. I especially hate the way I use two for loops to get data. There has to be a more efficient way.

I have got a Document Name Table in my SQL database and Files in Content Folder.
I have got a Two list- ListOfFileNamesSavedInTheDB and ListOfFileNamesInTheFolder.

Basically, I am getting all file names saved in Database and checking is it exist in the Folder, if not delete file name from the database.

 var clientDocList = documentRepository.Documents.Where(c => c.ClientID == clientID).ToList();

 if (Directory.Exists(directoryPath))
 
 string[] fileList = Directory.GetFiles(directoryPath).Select(Path.GetFileName).ToArray();
 bool fileNotExist = false;
 foreach (var file in fileList)
 
 foreach(var clientDoc in clientDocList)
 
 if (clientDoc.DocFileName.Trim().ToUpper()==file.ToUpper().Trim())
 
 fileNotExist = false;
 break;
 
 

 if (fileNotExist)
 
 //Delete file name from Database
 
 
 

c# linq

share

asked 2 mins ago

AliAzraAliAzra

11

New contributor

AliAzra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

$endgroup$

 var clientDocList = documentRepository.Documents.Where(c => c.ClientID == clientID).ToList();

 if (Directory.Exists(directoryPath))
 
 string[] fileList = Directory.GetFiles(directoryPath).Select(Path.GetFileName).ToArray();
 bool fileNotExist = false;
 foreach (var file in fileList)
 
 foreach(var clientDoc in clientDocList)
 
 if (clientDoc.DocFileName.Trim().ToUpper()==file.ToUpper().Trim())
 
 fileNotExist = false;
 break;
 
 

 if (fileNotExist)
 
 //Delete file name from Database
 
 
 

share

asked 2 mins ago

AliAzraAliAzra

11

New contributor

AliAzra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share

asked 2 mins ago

AliAzraAliAzra

11

New contributor

AliAzra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

AliAzraAliAzra

11

New contributor

AliAzra is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 2 mins ago

AliAzraAliAzra

11