mapping datatable to poco - This Dot Life

Topic 1 Post

mapping datatable to poco

How to: Convert datatable to Json object using Automapper and Newtonsoft

By Jsinh in c sharp on 18 Jun 2014

I had a weird experience before few days, I definitely knew how to solve the problem and I am sure it is the right way to do it. Thinking it would not be any different to map a datatable to POCO class(es) using Automapper. But it didn't turned out…

Topics

blog jsinh: 79 jsinh: 79 how to: 33 using C#: 21 c#: 16 asp.net: 13 asp.net mvc: 13 visual studio: 8 wpf: 7 asp.net 5: 7 web.config: 6 ghost: 6 ghost-blogging-platform: 6 windows 8: 5 .net: 5 asp.net mvc 5: 5 asp.net vnext: 5 .NET framework: 4 azure: 4 nginx: 4 mysql: 4 mvc: 4 asp.net mvc 5.1: 4 learning asp.net: 4 asp.net series: 4 on windows: 4 how to setup: 4 dotnet: 4 sql: 3 .NET framework 4.0: 3 windows: 3 blogging: 3 xml: 3 c sharp: 3 with sample: 3 nuget: 3 ubuntu: 3 ghost-blog: 3 install ghost: 3 ghost on ubuntu: 3 ghost on nginx: 3 ghost with mysql: 3 nodejs: 3 setup ghost: 3 download ghost: 3 using wpf: 3 mvvm: 3 postgresql: 3 postgre: 3 postgres: 3 postgres database: 3 vnext: 3 aspnet on linux: 3 xamarin: 3 xamarin forms: 3 message queue: 2 message queuing: 2 MSMQ: 2 xaml: 2 windows 7: 2 windows 8.1: 2 windows 10: 2 SQL Server 2012: 2 app.config: 2 sql connection: 2 AppDomain: 2 AppDomain.CurrentDomain: 2 internet information services (IIS) manager: 2 windows server 2008: 2 nuget package manager: 2 nuget package source: 2 visual studio 2012: 2 $windows.~BT: 2 clean up system files: 2 disk cleanup: 2 disk space: 2 diskcleanup: 2 windows.old: 2 node.js: 2 node package manager: 2 Getting Started: 2 vagrant: 2 vagrant-file: 2 vmware: 2 vmware-fusion: 2 vmware-fusion vagrant: 2 god's own machine: 2 assemble machine: 2 Cooler Master Vanguard 1000 Watts PSU: 2 build your own machine: 2 review: 2 c-sharp: 2 asp.net webapi: 2 appsetting in mvc: 2 xaml style: 2 using mvvm: 2 exception: 2 debug: 2 debugging in visual studio: 2 system.diagnostics: 2 mvvmlight: 2 postgresql on linux: 2 postgresql on ubuntu: 2 postgresql on ubuntu 14.04: 2 postgresql setup: 2 how to install: 2 glimpse: 2 profiling asp.net mvc: 2 kvm: 2 kpm: 2 kvm upgrade: 2 linux: 2 .net linux: 2 asp.net 5 console application: 2 asp.net on linux: 2 windows-azure: 2 jaspalsinh chauhan: 1 keywords: 1 method parameter: 1 out: 1 params: 1 ref: 1 introduction: 1 journal queues: 1 manage MSMQ: 1 msmq type id: 1 private queues: 1 public queues: 1 queue explorer: 1 compmgmt.msc: 1 ApplicationCommands: 1 wpf-commands: 1 routed commands: 1 routed ui commands: 1 routed command system: 1 animated: 1 custom application startup: 1 splash screen: 1 splashscreen: 1 application startup: 1 bootable windows 8: 1 create bootable windows 8: 1 usb flash drive: 1 windows 8 usb flash: 1 active directory: 1 adds: 1 configuring adds: 1 dns server: 1 domain hosting: 1 fqdn: 1 host your own domain: 1 netbios: 1 denali: 1 how to install SQL server: 1 install sql server: 1 sql server localdb: 1 step by step: 1 Dns.GetHostName: 1 get machine IP Address: 1 IP Address: 1 IPHostEntry: 1 LINQ: 1 Network API: 1 System.Net: 1 enable save tabs warning firefox: 1 firefox: 1 retore warning firefox: 1 showquitwarning: 1 warnonclose: 1 warnonquit: 1 warnonrestart: 1 App suspend: 1 debug location: 1 debug suspend state: 1 windows store app: 1 windows store app lifecycle model: 1 efficient blog post: 1 how to write blog post: 1 windows live writer: 1 wordpress tricks and trips: 1 .NET framework 3.5: 1 .NET framework client profile: 1 difference between: 1 .NET framework 4.5: 1 code first: 1 code first approach: 1 entity framework 5: 1 sql compact 4: 1 configuration file path: 1 get configuration file path: 1 god mode: 1 hidden feature: 1 tricks and tips: 1 unlock windows 8: 1 windows 8 hidden feature: 1 how to blog: 1 share information: 1 slumdog: 1 slumdog blogging: 1 why blog: 1 connectionstrings: 1 sqlclient: 1 code: 1 code at school: 1 code class: 1 code.org: 1 learn coding: 1 sample sqldependency: 1 service broker: 1 sql command: 1 sql notification: 1 sql queue: 1 Sql service broker: 1 SqlDependency: 1 sqlnotificationinfo: 1 sqlnotificationinfo.invalid: 1 sqlnotificationsource: 1 sqlnotificationtype: 1 encoding: 1 stringwriter: 1 utf-16: 1 utf-8: 1 AppDomain.CurrentDomain.SetupInformation: 1 AppDomainSetup: 1 conditional xml serialization: 1 sample: 1 shouldserialize: 1 xml serialization: 1 assembly file version: 1 assembly informational version: 1 assembly version: 1 auto increment: 1 auto increment version: 1 auto version number: 1 in .net: 1 add web server role: 1 add web server role services: 1 iis 7: 1 iis manager: 1 iis manager not found: 1 iis missing: 1 inetmgr: 1 where is iis manager: 1 add ftp role service: 1 ftp server: 1 ftp server in IIS: 1 ftp server in iis 7.5: 1 ftp server in iis 8: 1 how to configure ftp in iis: 1 how to create ftp site in iis: 1 iis 7.5: 1 iis 8: 1 windows server 2012: 1 how to access nuget without internet: 1 local nuget: 1 local package manger: 1 nuget server: 1 nuget.org is down: 1 nuget.org not available: 1 vs2012: 1 disableSourceControlIntegration: 1 enable package restore: 1 nuget package restore: 1 package restore: 1 souce control: 1 visual studio 2013: 1 upgrade to windows 8.1: 1 Windows upgrade log files: 1 booksleeve: 1 build-essential: 1 cmder: 1 console 2: 1 how to install redis: 1 how to install redis on ubuntu: 1 install redis: 1 redis: 1 redis 6379: 1 redis client: 1 redis on azure: 1 redis.config: 1 redis.io: 1 servicestack.redis: 1 sider: 1 ssh ubuntu: 1 start redis: 1 step by step guide: 1 stop redis: 1 ubuntu 13.10: 1 .NET runtime optimization service: 1 AutoNGEN: 1 common language runtime native compiler: 1 mscorsvw.exe: 1 NGEN: 1 NGEN.exe: 1 windows update: 1 ghost-blog-review: 1 first-look: 1 first-look-ghost: 1 handlebars: 1 ghost-debug: 1 ghost-backup: 1 markdown: 1 worpress vs ghost: 1 ssh: 1 secure ssh: 1 ssh on ubuntu: 1 nod: 1 ghost-digitalocean: 1 blog: 1 sitemap: 1 sitemap-generator: 1 needy ghost sitemap generator: 1 ghost sitemap: 1 virtual-box: 1 virtualbox vagrant: 1 introduction to vagrant: 1 vagrant for developers: 1 vagrant first look: 1 hyper-v: 1 vagrant init: 1 vagrant up: 1 vagrant boxes: 1 vagrant providers: 1 vagrant.d: 1 hashicorp: 1 vagrant cloud: 1 vagrant bridged network error: 1 virtual network editor: 1 vagrant ssh: 1 firstchanceexception: 1 appdomain.currentdomain.firstchanceexception: 1 exception handling: 1 exception handling in .NET: 1 spam: 1 spam emails: 1 scam: 1 scam emails: 1 Rober Adair: 1 Mr. Robert Adair: 1 teva uk limited: 1 stop spam: 1 herbal roots: 1 details of my proposal: 1 triga: 1 Intel 3.5 GHz LGA 1150 4770K i7 Processor: 1 Gigabyte GA-Z87X-OC Motherboard: 1 Corsair Vengeance DDR3 16 GB (2 x 8 GB) PC RAM: 1 ZOTAC NVIDIA GeForce GTX 650 Ti Boost 2 GB GDDR5: 1 SAMSUNG 830 Series 2.5-Inch 256GB SATA III MLC: 1 Cooler Master CM Chassis Trooper: 1 Hydro Series H110 280mm Extreme Performance Liquid CPU Cooler: 1 boolean operator: 1 equality operator: 1 AND: 1 OR: 1 EXCLUSIVE OR: 1 XOR: 1 operands: 1 convert datatable to json: 1 mapping datatable to poco: 1 using automapper: 1 using newtonsoft: 1 create hierarchical json object: 1 json: 1 delegates: 1 delegate: 1 multicasting in c#: 1 delegate and multicasting: 1 getinvocationlist: 1 MulticastDelegate: 1 mvc 5.1: 1 webapi 2.1: 1 asp.net webapi 2.1: 1 routing: 1 mvc routing: 1 two web.config: 1 webpages:Enabled: 1 appsetting: 1 webpages: 1 webpages:Version: 1 razor: 1 change background in wpf: 1 listbox in wpf: 1 listbox: 1 selected listboxitem: 1 change background color: 1 listbox resources: 1 listbox custom style: 1 camera-preview: 1 preview: 1 mvvm-light-toolkit: 1 aforge: 1 aforge-video: 1 aforge-controls: 1 windows presentation framework: 1 preview webcam: 1 video: 1 take snapshot: 1 in wpf: 1 mysql view: 1 mysql error 1449: 1 mysql definer: 1 error 1449: 1 script: 1 assert: 1 debug.assert: 1 contract check: 1 argument null exception: 1 null check: 1 dubuggerdisplay: 1 attribute: 1 relaycommand: 1 canexecute not working: 1 canexecute: 1 mvvmlighttoolkit: 1 galasoft.mvvmlight.platform: 1 galasoft.mvvmlight: 1 delete partition: 1 efi disk partition: 1 partition: 1 disk partition: 1 disk management: 1 efi system partition: 1 efi: 1 efi partition: 1 delete efi partition: 1 guid partition table: 1 diskpart: 1 list disk: 1 select disk: 1 diskpart clean: 1 create shortcut: 1 shortcut: 1 create shortcut programmatically: 1 IWshRuntimeLibrary: 1 Windows Script Host Object Model: 1 WshShell: 1 Environment.SpecialFolder.Desktop: 1 time sync: 1 ntp server: 1 ntp client: 1 time sync on windows: 1 time sync time interval: 1 auto time sync: 1 time.windows.com: 1 date and time settings: 1 drag-drop: 1 drag: 1 drop: 1 drag n drop: 1 drag and drop: 1 gong drag drop: 1 gong solution drag drop: 1 drag drop file: 1 drag drop wpf mvvm: 1 mssql: 1 sqlserver: 1 mssql query: 1 sql query: 1 get sql version: 1 google: 1 google drive: 1 change default folder path for google drive: 1 change google drive sync default folder: 1 cloud storage: 1 always backup: 1 change default sync folder: 1 default folder google drive: 1 microsoft office picture manager: 1 how to compress image: 1 compress image: 1 reduce image size: 1 using office picture manager: 1 how to reduce image size: 1 clickonce: 1 clickonce deployment: 1 clickonce package: 1 IIS: 1 clickonce on apache: 1 clickonce on nignx: 1 mime types for clickonce: 1 mime types: 1 .manifest: 1 .application: 1 protecteddata: 1 protectedmemory: 1 secure data: 1 encryption: 1 decryption: 1 security csharp: 1 system.security.cryptography: 1 powershell: 1 set-executionpolicy: 1 nuget install update error: 1 failed to initialize the powershell host: 1 nuget package manager console: 1 nuget update issue: 1 set executionpolicy allsigned: 1 install postgresql: 1 linux web server: 1 get postgresql version: 1 pg_hba.conf: 1 cidr: 1 cidr notation: 1 postgresql remote access: 1 postgre remote access: 1 postgresql.conf: 1 psql: 1 postgresql listen_addresses: 1 database: 1 database server: 1 primary key: 1 primary key constraint: 1 primary key postgresql: 1 no primary key on table: 1 table without primary key: 1 serial datatype in postgresql: 1 debugging asp.net mvc: 1 mvc5: 1 glimpse asp.net mvc: 1 glimpse nuget package: 1 profiling in production: 1 debugging in production: 1 project k: 1 k runtime: 1 .net open source: 1 visual studio community edition: 1 klr: 1 k run: 1 clr: 1 coreclr: 1 k package manager: 1 omnisharp: 1 why not blog: 1 everyone should blog: 1 blogging tips: 1 asp.net error page: 1 error page handling: 1 error page options: 1 useerrorpage: 1 KRE_ENV: 1 visual studio 2015: 1 visual studio 2015 ctp: 1 visual studio 2015 preview: 1 download visual studio: 1 visual studio 2015 released: 1 hosting on linux: 1 hosting aspnet 5 on linux: 1 hosting: 1 install mono: 1 aspnet mono: 1 kestrel: 1 aspnet welcome page: 1 aspnet 5 on azure: 1 hosting asp.net 5 on azure: 1 azure aspnet 5: 1 dnvm: 1 mono: 1 dnx: 1 dnvm restore: 1 dnu restore: 1 dnx . kestrel: 1 dnx trace: 1 asp.net 5 trace: 1 dnu pack: 1 asp.net 5 beta-4: 1 gnu linux: 1 postsharp: 1 aspect oriented programming: 1 aop: 1 profiling: 1 miniprofiler: 1 dry: 1 don't repeat yourself: 1 profiling using miniprofiler: 1 custom attribute: 1 create wpf style: 1 custom wpf scrollbar style: 1 macos like scrollbar in wpf: 1 scrollbar in wpf: 1 resource dictionary in wpf: 1 compileoptions: 1 languageversion: 1 project.json: 1 choose csharp language version: 1 asp.net 5 configuration: 1 asp.net 5 IConfiguration: 1 Microsoft.Framework.ConfigurationModel: 1 System.Configuration: 1 IConfigurationSource: 1 MemoryConfiguration: 1 CommandLineConfiguration: 1 IniFileConfiguration: 1 EnvironmentVariablesConfiguration: 1 JsonConfiguration: 1 XmlConfiguration: 1 ini files: 1 json files: 1 ASP.NET 5 Web Application: 1 custom configuration source: 1 microsoft: 1 visual studio code: 1 visual studio for windows: 1 visual studio for mac: 1 visual studio for linux: 1 mac os x: 1 C# development on linux: 1 release announcement: 1 visual studio editor: 1 code editor: 1 cross platform development editor: 1 viewstart.cshtml: 1 view must derive from webviewpage: 1 webviewpage: 1 ViewStartPage: 1 assemblybinding: 1 typeinitializationexception: 1 unhandled exception: 1 bindingredirect: 1 dependentassembly: 1 upgradeyourworld: 1 after upgrade to windows 10: 1 things to do: 1 $windows.~WS: 1 upgrade to windows 10: 1 xamarin android: 1 libpng warning: 1 Image optimizer: 1 remove EXIF and metadata: 1 SmushIt: 1 PunyPNG: 1 azure-mobile-service: 1 remote-debugging: 1 azure-remote-debugging: 1 azure-app-service: 1 app-mobile-service: 1 attach-debugger: 1 migrate-to-app-service: 1 couchbase: 1 couchbase-lite: 1 couchbase sync gateway: 1 sync gateway: 1 couchbase on ubuntu: 1 sync_gateway: 1 mobile sync: 1 mobile offline database: 1 offline sync: 1 asp.net core 1.0: 1 .net core 1.0: 1 .net core: 1 asp.net core: 1 azure-notification-hub: 1 notification-hub: 1 push-notification: 1 403 forbidden: 1 npm: 1 thanos: 1 Intel® Core™ i7-6900K Processor: 1 Asus X99 - Deluxe II: 1 VENGEANCE® LED 32GB (2 x 16GB) DDR4 DRAM 3200MHz: 1 ASUS GeForce® GTX 1070 Founders Edition: 1 SSD 960 PRO NVMe M.2 512GB: 1 Hydro Series™ H115i 280mm Extreme Performance Liquid CPU Cooler: 1 Cooler Master - Strom Trooper (Full Tower): 1 visual studio 2017: 1 xamarin mac agent: 1 xcode: 1 thisdotlife: 1 developer: 1 life: 1 anniversary: 1 programming: 1 sharing: 1 journal: 1 disclaimer: 0 post list: 0 archive: 0 all post: 0 barney and clyde: 0 tools: 0 softwares: 0 cloud services: 0 development tools: 0