Question

Currently i m developing a WPF + ASP.Net Application WPF at Desktop role as Club Manager while ASP.Net is used to allowed user register as club member Database plan to host at shared host SQL Server 2008 Both will connect to ASP.Net via LinQ to SQL

Now the problem i confuse and cannot solve that is Club is not only one while there might 1 snooker club and 2 days later may built up another pool club May i know how can i create a new * for while new club is setting up ? will create a new table inside the database will better than create a new database ?

will both application ASP.Net and WPF connect via LINQ will caused them a security holes ? any better suggestion ?

Thank you for reply and sorry if this post violate site rules ~.~ because of currently rush for assignment and need to know clearly on what technology is available to me =D

Answer 1

我不全心全意地肯定你们会怎样做。但我认为你指的是,你如何能够拥有多个“俱乐部”。

答案取决于您的要求。例如,辅助俱乐部是否需要使用不同的服务器(可能位于不同的接收设施?)。如果是,你需要为每个俱乐部保存数据库。

如果申请总是在服务器上运行,而且你完全控制这些服务器,那么你就可以设计一个俱乐部甄选栏的数据库,并通常使其成为你的主要钥匙。甚至没有必要设立一个新的表格。

如果你需要从一个俱乐部到另一个俱乐部的不同数据,那么你会得出一个新表格的唯一理由,甚至还有解决这一问题的其他方法。

Answer 2

如果你的数据库设计正确,你就只能创建一套新的记录,而不是一个新的数据库或新的表格。

友情链接