Вопрос по c#, sql, web-services – Лучшая практика: прямой доступ SQL против веб-службы

18

With respect to an application that has both a web and desktop client version:

  1. What is the best practice for the desktop client which needs access to a SQL Server?
  2. What are the benefits of connecting to the database from the application vs using a web service?
  3. Which one provides better security?
  4. What type of scope would call for one vs the other (enterprise intranet vs. web app, etc)
  5. Are there any other considerations that are necessary when choosing on platform?

Ваш Ответ

5   ответов
3

3

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

15

What is the best practice for the desktop client which needs access to a SQL Server?

Error: User Rate Limit Exceeded

What are the benefits of connecting to the database from the application vs using a web service?

Error: User Rate Limit Exceeded

Which one provides better security?

Error: User Rate Limit ExceededpeopleError: User Rate Limit Exceeded

What type of scope would call for one vs the other (enterprise intranet vs. web app, etc)

Error: User Rate Limit Exceeded

Are there any other considerations that are necessary when choosing on platform?

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

& quot; поскольку пользователь не может получить к нему прямой доступ & quot; - как насчет случая, когда доступ к БД ограничен выполнением хранимых процедур? Все прямые SELECT / UPDATE / DELETE запрещены. Существует ли риск для безопасности на уровне порта MS SQL, который является более слабым, чем доступ к порту веб-сервера?
16

Error: User Rate Limit Exceeded

  1. Write an independent data access assembly that will talk to the database.
  2. If you are looking for interoperability between different platforms/clients then expose this assembly as a SOAP web service.
  3. If you are looking for performance use the assembly directly in your client .NET applications.
+1 за короткий и краткий ответ.
какая-либо конкретная причина упоминания приложений .NET в конце?
7

Error: User Rate Limit Exceeded

Error: User Rate Limit Exceeded

Похожие вопросы