Geeks With Blogs

News Ashraful Alam Joy

Create Your Badge

Ashraful Alam is a Software Architect, who has 8 years of professional experience in Software Development industry. This Bangladeshi national is involved with project management and development of several US based software projects from his country. Already he has managed and developed several software projects, which are being used by several users of different countries, such as USA, Canada, Australia, and Bangladesh. While developing and managing a team, he contains and maintains a set of well defined engineering practices developed by him and other online developer communities.

Due to his willingness to give effort to improve and share better software development practices, Ashraf has been awarded as “Most Valuable Professional” (MVP) in ASP.NET category by Microsoft since year 2007 multiple times, which is a rare honor and prestigious reorganization among the developers around the world.

Check his portfolio to know more about him and his works.

.NETTER Characters... Every part of your life is best, if you can know yourself and thus create your life like an artist!

1. In a case, where we are considering m2m, and it’s required to add a new entity record in the m2m table, an obvious case comes, where we create and save the entity first and then we add that entity in the m2m table. For example, when we add a new book to an exiting author’s book list, we first create a “Book” object and save it, and then we add this book to the author book list thru a static method. However, in that case, we might have to consider database server side or application level (ex: COM+) transactions, where the whole operation will be rolled back for any unsuccessful process in the full operation path.

2. While attaching the m2m table to a o2m table, in this case we have to perform data operations in two separate tables. We can do this either in the stored procedure layer at one time, where all required data will be passed thru stored procedure parameters and the stored procedure will perform operations in the separate table. Or this can be done separately from the application layer, which is useful, when we contain a very common format for CRUD operations for each and every database table in the stored procedure layer (generally when we generate CRUD stored procedures).

Posted on Thursday, July 6, 2006 3:56 AM Architecture , Database , .NET | Back to top

Comments on this post: Custom Entity – Data Operation on Multiple Tables

No comments posted yet.
Your comment:
 (will show your gravatar)

Copyright © Ashraf Alam | Powered by: