c# - How do I get parts of Blacklist checked -

if (!blacklist.contains(tabname) && (allowedschemas.contains(schname)) ) {     string schemaname = getstringfromreader(reader, "schemaname");     string tablename = getstringfromreader(reader, "tablename");     string description = getstringfromreader(reader, "description");     string columnname = "null";      tabinfo.add(new tableinfo(schemaname, tablename, columnname, description)); } 

this code have problem. example have tabname= bspname , in blacklist= bsp. need here true.

now gives me true if blacklist == tabname.

so need sth in mssql: tabname not %@blacklist%

i hope understand question

janik

you need tabname not %@blacklist% need check in string means need apply contains on string below

var match = blacklist.firstordefault(s=>tabname.toupper().contains(s.toupper())); if( match==null && (allowedschemas.contains(schname)) ) {   ..your code }