how to find MS-SQL records corresponding to a binary string

sepehr shams

11y1.3kLINQ

how to read records from MS-SQL -corresponding to a binary string- to generic collection , suppose that our string is "10100" , corresponding records would be the 0-th, and second rows in table ("Operation" for example). one amateur (and of course incomplete) answer could be :

      public ICollection GetAllowedOperations(string accessString)  
   {     
       PanelModel dbContext=new PanelModel();   
       var operationArray = dbContext.Operations.ToArray();//load from db to array       
       char[] accessArray = accessString.ToCharArray();//convert string to array       
        for (int i = 0; i <=accessArray.Count(); i++)//remove corresponding to 0       
            {    
              if(accessArray[i].Equals('0'))          
                  {     
                     operationArray[i] = null; 
                  }  
            }                   
            //assign array to a generic collection for future computation  what is an appropriate solution ,

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes11y ago
If I've understood it correctly, try this:

public ICollection GetAllowedOperations(string accessString)
{
PanelModel dbContext=new PanelModel();
var operationArray = dbContext.Operations.ToArray(); // load from db to array
char[] accessArray = accessString.ToCharArray(); // convert string to array
var filteredList = new List();

for (int i = 0; i <= accessArray.Count(); i++) // filter out corresponding to 1
{
if(accessArray[i] == '1')
{
filteredList.Add(operationArray[i]);
}
}

return filteredList;
}