Find Jobs
Hire Freelancers

C# Newtonsoft Json data, value to assign empty list, so that the sqlcommand insert statement doesn't fail

$10-30 USD

In Progress
Posted over 3 years ago

$10-30 USD

Paid on delivery
We have some columns that are empty at times and we don't want the t-sql query to get null object reference error. One is the formattedNumber. What value do you assign to an empty json string so that the sqlcommand doesn't fail? //Example //many columns can be null //check for variable is null, if null assign a non value value so the insert and update statements don't fail, possibly dbnull IList<Landlines> personcommunicationlandlines = [login to view URL]; //if personcommunicationlandlines not null do this if (personcommunicationlandlines != null) { if ([login to view URL] > 0) { string formattedNumber = personcommunicationlandlines[0].formattedNumber; //Get id value of first element of array } else //Assign dbnull to variable { personcommunicationlandlines = null; //What to assign here for null json string? string formattedNumber = null; } } Line from listing attached [login to view URL]("@personcommunicationlandlines", personcommunicationlandlines[0].formattedNumber); Full Listing attached Please reply with: The time of day that you are available. I am available 7am to 10pm UTC-06:00 Central Time US & Canada The answer for the question Confidentiality. a) No Use. Recipient agrees not to use the Confidential Information in any way, or to manufacture or test any product embodying Confidential Information, except for the purpose set forth above. b) No Disclosure. Recipient agrees to use its best efforts to prevent and protect the Confidential Information, or any part thereof, from disclosure to any person other than Recipient's employees having a need for disclosure in connection with Recipient's authorized use of the Confidential Information. c) Protection of Secrecy. Recipient agrees to take all steps reasonably necessary to protect the secrecy of the Confidential Information, and to prevent the Confidential Information from falling into the public domain or into the possession of unauthorized persons. d) Scope. The scope of Confidentiality is deemed to be in all contracts present past and future with the Parties to this request.
Project ID: 28806252

About the project

10 proposals
Remote project
Active 3 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $34 USD for this job
User Avatar
Hi there! I can get this done. actually there is some wrong parameters passed in cmd. I may need to talk with you regarding this. please ping me.
$107 USD in 1 day
5.0 (31 reviews)
6.0
6.0
User Avatar
Hi.. I am available 8am to 3am Pakistan Time I hope you are fine and in good health with the COVID-19 situation globally. I've read the job description and I've previous Experience related to your job. I am an Experienced Desktop and Web Applications Developer having 3 plus years of valuable experience in C#, C++, Asp.net Web Forms,Asp.net MVC, SQL Server, MY SQL, SSRS (SQL Server Reporting Services), Crystal Reports. I am interested to work with you. Looking Forward for your response. Thanks. Muhammad Asad.
$30 USD in 7 days
5.0 (32 reviews)
5.4
5.4
User Avatar
Hi.. I Exactly Understand your requirements. I am an Experienced Desktop and Web Applications Developer having 3 plus years of valuable experience in C#, Asp.net Web Forms,Asp.net MVC, SQL Server, MY SQL, SSRS (SQL Server Reporting Services). I am interested to work with you. Kindly Hire me. Thanks. Usama Anjam
$20 USD in 7 days
5.0 (24 reviews)
5.0
5.0
User Avatar
Hi. i am available whole day I have expertise in C# with more than 10 year of experience. I can handle any kind of task and assure you that you will get good quality of work. I am interested in working with you on this project and I am willing to proceed further with the discussion. Please send me a message and we can have a quick chat right away. because i have few questions about your query I am waiting for your positive response. Best Regards, Alphatech
$30 USD in 1 day
5.0 (37 reviews)
5.1
5.1
User Avatar
Hello, I am software developer more than 10 years. I have developed desktop apps with Vb.Net and MS SQL database in my previous job. I have co worked with senior software developers of Microsoft. I was a member of team which have developed national vehicle registry software. I have hands on experience object oriented programming, multi threading, web services, relational database design. I have just completed C# software about Win32 functions. I can do the task in utmost 3-4 hours. Regards.
$20 USD in 1 day
5.0 (12 reviews)
4.3
4.3
User Avatar
Hello, I m a certified C# .NET developer with 4 years of experience. I alreay did similar projects. I m available... Ping me for more details..............................
$25 USD in 1 day
4.9 (23 reviews)
4.4
4.4
User Avatar
*** EXPERT C#.NET DEVELOPER *** Main Problems in your script: 1. no try,catch for exception handling found 2. no null exception handling found I may resolve your Null exception/error and provide you it in more better way. Contact me to discuss more.
$30 USD in 1 day
5.0 (9 reviews)
3.9
3.9
User Avatar
Hi, I understand your issue and I can fix it soon. I have been working on C# Application development for 5 years and I often use Newtonsoft Json lib and sql. If you hire me, I will provide good result. Thanks for your reply.
$30 USD in 1 day
5.0 (1 review)
0.6
0.6
User Avatar
A lot of experience with C#. A lot of experience with sqlcommands A lot of experience with Sql databases / TSQL
$20 USD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
SAN ANGELO, United States
5.0
284
Payment method verified
Member since Jul 28, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.