Comments by paingiver (Top 4 by date)

I've tried your solution but didn't get it to work, please check my edited question. I'm Trying to work on events please give me example through c# coding thanks

Thanks for your suggestion Meysam Tolouee, Can you please guide me on how to work with views using Entity-framework I've no idea of views

thanks AndrewCharlz for your solution I'm going to implement it...