无法使用lightswitch中的代码插入数据

在发布应用程序时提供适当的连接字符串，我能够将使用LS创建的角色，权限和用户映射到ASPNET_Membership表，如aspnet_users SQl Server 2008中的，aspnet_roles等。

Giving appropriate connection string while publishing the application, I'm able able to map the roles, permissions and users created using LS with the ASPNET_Membership tables like aspnet_users, aspnet_roles, etc. in SQl Server 2008.

aspnet_users有像UserId =>这样的列。 uniqueidentifier（datatype），UserName => nvarchar（256）等我创建了另一个表 作为EmployeeDetails，其中包含EmployeeID，Name等列。还有4个列，例如

aspnet_users have columns like UserId => uniqueidentifier(datatype), UserName => nvarchar(256), etc. I have created one more table as EmployeeDetails having columns like EmployeeID, Name,etc. with 4 more columns like

CreatedBy => uniqueidentifier（UserId用作aspnet_Users表中的foreignKey），

CreatedBy => uniqueidentifier (UserId used as foreignKey from aspnet_Users table),

CreatedOn => datetime，

CreatedOn => datetime,

ModifiedBy => uniqueidentifier（UserId用作aspnet_Users表中的foreignKey），

ModifiedBy => uniqueidentifier (UserId used as foreignKey from aspnet_Users table),

ModifiedOn => datetime。

ModifiedOn => datetime.

因此，在网格上显示数据时，我希望看到插入新数据的用户名（在CreatedBy列中）以及之后修改数据的人（在ModifiedBy列中）以及日期。

So while displaying data on grid I would like to see the username who inserted new data (in CreatedBy column) and who modified the data later (in ModifiedBy column) along with the dates.

上述4列（CreatedBy，CreatedOn，ModifiedBy和ModifiedOn）中的数据应该通过编写一些代码自动进行。不应允许用户通过添加数据屏幕为这些列添加数据。

The data in the above 4 columns (CreatedBy, CreatedOn, ModifiedBy and ModifiedOn) should go automatically by writing some code. User should not be allowed to add data for these columns through Add data screen.

您能告诉我在哪里以及如何编写代码来实现此功能吗？此外，当用户登录应用程序时，如何使用上述方案向他显示用户特定数据？

Can you tell me where and how to write a code to achieve this functionality? Also when a user logs in the application, how to show him user-specifc data using above scenario?

（例如： - 如果用户名"abc"已输入2名员工，则登录后他应该只看到那2名员工。

(Eg:- If username "abc" has entered 2 employees, then after login he should see only those 2 employees).

谢谢。