Issue

When you generate an SQL table name that contains periods/dots and you generate a SmartObject based on that table, the SmartObject will only have a "list" method. 

Symptoms

The CRUD methods (Create, Read, Update and Delete) will not be auto generated for you.

As an example, if you create an SQL table, with the name dbo.Employee.Information:

Image

This will result in a SmartObject that has a "List" method only:

Image

Resolution

As a workaround, you can use an underscore, instead of a period.

Image

When doing this, K2 will generate the list, and all of the CRUD methods for you, as expected.

Image

Please see the "Considerations" section in the following article for more information:

http://help.k2.com/onlinehelp/k2five/userguide/5.1/default.htm#ServiceBrokers/SQLServer/SQL-Server-Service.htm 

We have logged an item for the development team to look at. If deemed viable, this issue should be addressed in a future release of K2.