如何使用C#将此代码转换为linq到sql [英] How to convert this code to linq to sql using c#

问题描述

'j_' + (CHAR(64+DATEPART(MONTH,getdate()))
+CONVERT(VARCHAR,DATEPART(day,getdate()))
+CHAR(65+DATEPART(HOUR,getdate()))
+CONVERT(VARCHAR,DATEPART(MINUTE,GETDATE()))
+CONVERT(VARCHAR,DATEPART(SECOND,GETDATE())))

How to write this code in c# using linq to sql?

推荐答案

我可以告诉你它的作用，然后确定可以将其转换为csharp函数:

CHAR(64+DATEPART(MONTH,getdate())):将月份号转换为"A" ..."L"

CONVERT(VARCHAR,DATEPART(day,getdate())):将今天1..31的天数提取为varchar

CHAR(65+DATEPART(HOUR,getdate())):将当前时间映射到"A" ..."Y"

CONVERT(VARCHAR,DATEPART(MINUTE,GETDATE())) :将当前分钟0..59提取为varchar

CONVERT(VARCHAR,DATEPART(SECOND,GETDATE())) :将当前分钟0..59提取为varchar

最后，它将它们全部连接到"j_"

顺便说一句，如果它产生唯一的标识符，那不是一个好方法，因为如果每秒有一个以上的请求，它将产生重复的标识符.

祝你好运

I can tell you what it does and then I am sure that you can convert it to a csharp function :

CHAR(64+DATEPART(MONTH,getdate())) : It converts month number to ''A'' ... ''L''

CONVERT(VARCHAR,DATEPART(day,getdate())) : It extract day number of today 1..31 as a varchar

CHAR(65+DATEPART(HOUR,getdate())) : It maps current hour to ''A'' ... ''Y''

CONVERT(VARCHAR,DATEPART(MINUTE,GETDATE())) : It extract current minute 0..59 as a varchar

CONVERT(VARCHAR,DATEPART(SECOND,GETDATE())) : It extract current minute 0..59 as a varchar

At the end, it concatenates all of them to ''j_''

BTW, If it produces unique identifiers it is not a good approach because if there were more that one request persecond it will generate duplicate ones.

Good Luck

这篇关于如何使用C#将此代码转换为linq到sql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！