• Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
  • Asset Store
  • Get Unity

UNITY ACCOUNT

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account
  • Blog
  • Forums
  • Answers
  • Evangelists
  • User Groups
  • Beta Program
  • Advisory Panel

Navigation

  • Home
  • Products
  • Solutions
  • Made with Unity
  • Learning
  • Support & Services
  • Community
    • Blog
    • Forums
    • Answers
    • Evangelists
    • User Groups
    • Beta Program
    • Advisory Panel

Unity account

You need a Unity Account to shop in the Online and Asset Stores, participate in the Unity Community and manage your license portfolio. Login Create account

Language

  • Chinese
  • Spanish
  • Japanese
  • Korean
  • Portuguese
  • Ask a question
  • Spaces
    • Default
    • Help Room
    • META
    • Moderators
    • Topics
    • Questions
    • Users
    • Badges
  • Home /
avatar image
Question by harti177 · Jan 08, 2021 at 02:30 AM · linqenumerate

Datatable.AsEnumerable()

Datatable.AsEnumerable() giving me the error NullReferenceException: Object reference not set to an instance of an object

 using UnityEngine;
 using System.Data;
 using System.Linq;
 using System;
 
 public class CAS_Test : MonoBehaviour
 {
     // Start is called before the first frame update
     void Start()
     {
         DataTable testTable = new DataTable("testTable");
         Console.WriteLine(testTable.AsEnumerable());
     }
 }

Error

NullReferenceException: Object reference not set to an instance of an object System.Data.DataTableExtensions.AsEnumerable (System.Data.DataTable source) (at :0) CAS_Test.Start () (at Assets/CAS_Test.cs:12)

I have also tested with data in the data table. This happens only in Unity . I tested in with a c# compiler and the two lines works.

I need this to use Linq query.

Comment

People who like this

0 Show 2
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users
avatar image sacredgeometry · Jan 08, 2021 at 06:44 AM 0
Share

What is the actual exception being logged. Are you sure it's that line? The docs seem to think that it doesn't throw that exception.

https://docs.microsoft.com/en-us/dotnet/api/system.data.datatableextensions.asenumerable?view=net-5.0


I mean I cant imagine there is a case in a .net provided class where construction fails. Especially in that manner (if it's even possible at all to set this to a null reference in the constructor (I am pretty sure it isn't)).

avatar image harti177 sacredgeometry · Jan 08, 2021 at 06:44 PM 0
Share

It is in that line. I have updated the question with complete code and error message.

1 Reply

· Add your reply
  • Sort: 
avatar image
Best Answer

Answer by harti177 · Jan 08, 2021 at 07:01 PM

Using ".Net 4.x" seems to resolve the issue.

The setting is under ProjectSetting -> Player -> OtherSettings -> Api Compatibility level

Comment

People who like this

0 Show 0 · Share
10 |3000 characters needed characters left characters exceeded
▼
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Viewable by all users

Your answer

Hint: You can notify a user about this post by typing @username

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Welcome to Unity Answers

If you’re new to Unity Answers, please check our User Guide to help you navigate through our website and refer to our FAQ for more information.

Before posting, make sure to check out our Knowledge Base for commonly asked Unity questions.

Check our Moderator Guidelines if you’re a new moderator and want to work together in an effort to improve Unity Answers and support our users.

Follow this Question

Answers Answers and Comments

111 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Enumerations Varibles 1 Answer

Unity doesn't recognize "List" object type (Linq) 2 Answers

Getting NullReferenceException: Object reference not set to an instance of an object when using Linq reading an xml file. 1 Answer

GameManager value tracking design issue 1 Answer

Can enumerators modify public script variables? 1 Answer


Enterprise
Social Q&A

Social
Subscribe on YouTube social-youtube Follow on LinkedIn social-linkedin Follow on Twitter social-twitter Follow on Facebook social-facebook Follow on Instagram social-instagram

Footer

  • Purchase
    • Products
    • Subscription
    • Asset Store
    • Unity Gear
    • Resellers
  • Education
    • Students
    • Educators
    • Certification
    • Learn
    • Center of Excellence
  • Download
    • Unity
    • Beta Program
  • Unity Labs
    • Labs
    • Publications
  • Resources
    • Learn platform
    • Community
    • Documentation
    • Unity QA
    • FAQ
    • Services Status
    • Connect
  • About Unity
    • About Us
    • Blog
    • Events
    • Careers
    • Contact
    • Press
    • Partners
    • Affiliates
    • Security
Copyright © 2020 Unity Technologies
  • Legal
  • Privacy Policy
  • Cookies
  • Do Not Sell My Personal Information
  • Cookies Settings
"Unity", Unity logos, and other Unity trademarks are trademarks or registered trademarks of Unity Technologies or its affiliates in the U.S. and elsewhere (more info here). Other names or brands are trademarks of their respective owners.
  • Anonymous
  • Sign in
  • Create
  • Ask a question
  • Spaces
  • Default
  • Help Room
  • META
  • Moderators
  • Explore
  • Topics
  • Questions
  • Users
  • Badges