Few Knobs & Dials Over WCF & Entity Framework.

     Hi everyone, we will see some few errors and their workarounds to fix those errors, which occur commonly while you building up a service layer using WCF with Entity Framework for data access.

Before moving to this topic, just a question for you, 

- Are You A PHONY?

     If your answer is No. Then, you have settled. Or you adjusted yourself, to the routine work, or you felt content with what you have learnt (No comments about you :P ).

     But if your answer is Yes.  Then continue reading.... :P

     Being a developer, that too, Full-Stack Developer (not Front or Back End, neither Client/Server Side) it's an End-To-End Development. Almost covers, 5 to 6 languages stack at the same time, it's OK, that you could google some time, but I'm sick of googling the topics, and copy paste the code, do some modifications to my requirements / issues. I'm doing this for half the decade... And the race is how fast you could google and resolve. 

     I'm trying to get rid of this, by practicing the following steps.

STEPS

1. For any issue, or exception arises, first don’t move your mouse to select the entire exception. And paste in Google. Instead read the exception fully first. 

2. Try to fix the exception, using your IDE itself. By trying few more options, like re-creating objects with additional parameters, or trying the same method with few additional parameters.... These small additional parameters, will close your exceptions, 

For Eg :

 1) 

DataAdapterObj.Fill(DataSetObj); // Fill the select query data, into the DataSet container 

 But if your query returning 50 million record, you could re-write the above line, to  

DataAdapterObj.Fill(DataSetObj,10000); // Fetches 10000 records at a time.

3. Exceptions doesn't get resolved by STEP - 2, Go to MSDN., read the namespace, along with methods, [strictly not google or stack overflow]

It's hard first, to stop googling and takes much time to resolve the issues, BUT everything comes by practice....

And to your phony problem, read this how-to-not-be-a-phony

Coming back to the topic,

Few Errors & their resolutions, while using EF & WCF were found here

At Last,

"You are no better and no worse than you actually are."

And

“No One Is Perfect In This World, All Were Nearing & Trying To Be Perfect.”

Happy Fixing Yourself :)