Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

linq data from sql table

Home
Forums
Learn iOS Programming

linq data from sql table

swapna

5yAsked Mar 15, 2021, 9:32 AM922Learn iOS Programming

How to fetch data from table if customer pass null value as input feild?,I have data in my tabled with value null. I want to pass is null in linq

6 Replies

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

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Jaimin Shethiya5y ago
Accepted answer
Hello

you can just write the below line

var customerList = _context.Customers.Where(x=> x.Name == null || x.Name == string.Empty).ToList();

Thanks
Rijwan Ansari5y ago
If your value is null as string then use below sample:
var customer = _context.Customers.where(x=>x.ColumnName ==Null ||
x.ColumnName =="Null" ).ToList();
Satya Karki5y ago
You can simply use this if Customer name is null
var customer = _context.Customers.ToList();
var result = customer.Where(s=>s.Name==null);
Jignesh Kumar5y ago
Hi,

Please use this one for employee Name column has null data,
var result = from emp in _context.employee
                                 where emp.Name == null
                                 select emp;
Kiran Mohanty5y ago
Try as below.
_context.Products.Select(p=> p.Description == input); //input holds null value
Sachin Singh5y ago
var All= YourContext.Employees.ToList();
var res=All.Where(x=>x.Name==null);