且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

我可以从Tables中删除默认ID吗?

更新时间:2023-12-05 21:06:10

目前无法删除"内在"的现有ID。在LS的B2中的表。另一种方法是在SQL Server(包括SQL Express)中创建一个外部数据库,并将其作为外部数据源附加。我们被告知下一个版本的
(如果我没记错的话,RTM)会给你一个GUID作为主键的选项。

There is currently no way to delete the existing id of an "intrinsic" table in B2 of LS. The alternative is to create an external database in SQL Server (including SQL Express) & attach it as an external data source. We've been told that the the next version (the RTM if I remember correctly) will give you the option to have a GUID as the primary key though.

V1也没有内置的执行SQL语句的方法,但如果您有Visual Studio Pro或更高版本,则可以创建自定义RIA服务。这并不像你想象的那么难,这是一篇很好的文章,

我如何:显示基于聚合数据的图表
,来自微软的Eric Erhardt。不要担心这是创建聚合查询以在图表中显示,它表明创建RIA服务是多么容易。

V1 also has no built-in way of executing SQL statements, but if you have Visual Studio Pro, or higher, you could create a custom RIA service. It's not as hard as you may think, here's an excellent article, How Do I: Display a Chart Built on Aggregated Data,  from Microsoft's Eric Erhardt. Don't worry that this is creating an aggregate query for displaying in a chart, it demonstrates how easy it is to create a RIA service.