I am trying to create a Temp table in the DB in order to INNER JOIN it to another table.

I have a method that gets an IE,c#,sql,string,list,linq"/>

时间戳

首页 > 解决方案 > IEnumerable which contains an int type that I wish to put in between parenthesis

I am trying to create a Temp table in the DB in order to INNER JOIN it to another table.

I have a method that gets an IE

c# - IEnumerable which contains an int type that I wish to put in between parenthesis

I am trying to create a Temp table in the DB in order to INNER JOIN it to another table.

I have a method that gets an IE

问题描述

I am trying to create a Temp table in the DB in order to INNER JOIN it to another table.

I have a method that gets an IEnumerable<Object> as a parameter. By using LINQ and String.Join() I am able to put a string in between each value I need for example String.Join("), ", SapMaterialIDs.Select(id => id.SapMaterialId) this creates a string that looks like 1),2),3),... However I need the leading parenthesis '(' I am trying to come up with a solution that doesn't make me do extra stuff in my code. for example I could do a List<string> list = str.Split("),").ToList() and do a loop that adds the leading ( to every value but I am definitely not a fan of this approach.

Also I am fairly new to asking questions here, so any tips are greatly appreciated. Thank you

Note that I don't want to use a SQL statement that uses the IN(...); therefore I am trying to create a Temp table and use it to JOIN, but I need my string in (#), (#), format.

Why not simply do this?

String.Join(", ", SapMaterialIDs.Select(id => id.SapMaterialId.ToString("(#)"))

BTW, next time, clearly specify what you have and what you need. For example, "I have an array of int and I need them in a string like (1), (2), (3), .... :)

I am not sure how the DB or the joins have anything to do with this, but if you give more context, there might be a simpler way to do what you need.

标签： c#sqlstringlistlinq

解决方案

为什么不简单地这样做呢？

String.Join(", ", SapMaterialIDs.Select(id => id.SapMaterialId.ToString("(#)"))

顺便说一句，下一次，清楚地说明你有什么和你需要什么。例如，“我有一个 int 数组，我需要将它们放在一个字符串中，例如(1), (2), (3), ....:)

我不确定数据库或连接与此有什么关系，但如果您提供更多上下文，可能会有更简单的方法来完成您需要的操作。

推荐阅读