Hi guys I am new to Sharepoint. Is it a good practice to query the content database tables through the SQL Server Management studio?
大家好,我是Sharepoint的新手。通过SQL Server Management工作室查询内容数据库表是一种好习惯吗?
Which things need to be considered for Sharepoint testing? As of now I have considered Authorizations and Performance of Sharepoint portal.
Sharepoint测试需要考虑哪些事项?截至目前,我已经考虑过Sharepoint门户的授权和性能。
Still there are lot of things need to be considered but since I am new to Sharepoint can anyone please guide me on how we do Sharepoint testing and things to be considered for Sharepoint testing?
仍有许多事情需要考虑,但由于我是Sharepoint的新手,任何人都可以指导我们如何进行Sharepoint测试以及要考虑进行Sharepoint测试的事情吗?
Any help really appreciated. Thanks in advance.
任何帮助真的很感激。提前致谢。
3 个解决方案
#1
Annop, I can answer your first question. The best practice is to use the Sharepoint API to access the database. The Sharepoint database is proprietary to Sharepoint, and Microsoft recommends that it not be accessed directly (or at least never written to directly). The database contains field names like StringField1, StringField2, NumericField1, etc. so composing a meaningful SQL query would be difficult.
Annop,我可以回答你的第一个问题。最佳做法是使用Sharepoint API访问数据库。 Sharepoint数据库是Sharepoint专有的,Microsoft建议不要直接访问它(或者至少不要直接写入)。该数据库包含StringField1,StringField2,NumericField1等字段名称,因此组成有意义的SQL查询将很困难。
#2
Regarding your second question, the following link contains several resources to help you with Sharepoint testing:
关于第二个问题,以下链接包含几个可帮助您进行Sharepoint测试的资源:
http://jopx.blogspot.com/2009/03/sharepoint-unit-testing.html
#3
here is a link to help unit testing sharepoint with mocking http://www.typemock.com/sharepointpage.php
这里有一个链接来帮助单元测试sharepoint与模拟http://www.typemock.com/sharepointpage.php
Hope it helps
希望能帮助到你
#1
Annop, I can answer your first question. The best practice is to use the Sharepoint API to access the database. The Sharepoint database is proprietary to Sharepoint, and Microsoft recommends that it not be accessed directly (or at least never written to directly). The database contains field names like StringField1, StringField2, NumericField1, etc. so composing a meaningful SQL query would be difficult.
Annop,我可以回答你的第一个问题。最佳做法是使用Sharepoint API访问数据库。 Sharepoint数据库是Sharepoint专有的,Microsoft建议不要直接访问它(或者至少不要直接写入)。该数据库包含StringField1,StringField2,NumericField1等字段名称,因此组成有意义的SQL查询将很困难。
#2
Regarding your second question, the following link contains several resources to help you with Sharepoint testing:
关于第二个问题,以下链接包含几个可帮助您进行Sharepoint测试的资源:
http://jopx.blogspot.com/2009/03/sharepoint-unit-testing.html
#3
here is a link to help unit testing sharepoint with mocking http://www.typemock.com/sharepointpage.php
这里有一个链接来帮助单元测试sharepoint与模拟http://www.typemock.com/sharepointpage.php
Hope it helps
希望能帮助到你