ASP.NET MVC: LINQtoSQL Class Limitations


I am developing an application in MVC and suddenly found some problems while using LINQtoSQL class.

1) In It’s class tables will be converted as an object.
It will keep the size of all attributes as your database structure.
So If you use it on model binding, then larger string will not be set to the Object.
So, you can not validate it on server side. yet you can show exception but you will never be
able to catch it!

2) If you give two foreign keys of the same primary table then you will get join names Like
customerMaster1, customerMaster2……. & It becomes hell to change it!!

I have just started blog witting…. So your comments will be appreciated….