Desing And Implementation Of Family Social-Networking-Services Web Site Integrateed Sina Micro-Blog

With the rapid developing of the SNS, SNS has become the very important platform for the communication and entertainment for the Internet users. But the current SNS site most care about the entertainment, making friends, etc, with the individual user as the unit. None of them focus on the family. From this side, this system make developing SNS website and family entertainment together to open a new field of SNS website mode. To satisfy most potential needs of our customers.Data access, I use Microsoft ORM Framework ado.net Entity Framework 4.0. Because the current main programming mode is object-oriented programming, but database is two-dimensional structure in the relational database, the interaction between them will display an "impedance mismatch". Although class's structure can usually close to reflect the organizational structure of a relational database table, but the corresponding relation is not perfect. More than one standardized form corresponding to a single class, usually the relationship between classes and tables relationship is not identical either, such as database table has not the inheritance relationship of object-oriented ideas. The entity framework is not just another object-relational mapping solution. Essentially, its role is to make applications can access and change the conceptual model with entities and relationships in the form of data. The entity framework used model and mapping file for conceptual model of information in the object of type entities that are specific to convert data source query to the object query.The system also use the very popular Sina Micro-Blog and had a very good of integration, the user can login our system using the Sina Micro-Blog account. Meanwhile the system can publish the private message to the Sina Micro-Blog. That can greatly improve the increase in the number of user.This paper first introduces to SNS web site and Sina Micro-Blog Platform related concepts; secondly introduced the Microsoft ORM Framework ado.net Entity Framework system structure, etc. Then in these theories foundation, a SNS family social networking site was design and realize. Specific include:in-depth analysis of the website system demand background, designed a system structure and function module chart and in SQL Server 2005 creates system database logic model and physical model. In the end, find out the solutions for the issue, such as the inheritance relationship between two entities, store procedures mapping, object lazy load, Oauth identity verification. In the last section of this paper is summarization, and give the proposes for the further work.Based on the entity framework and the Sina Micro-Blog Open Platform, the SNS family social networking sites system has been designed and implemented, form my paper, it proves that this web site solution is feasible and has high practical value.