{"action":"created","issue":{"url":"https://api.github.com/repos/sapiens/SqlFu/issues/69","labels_url":"https://api.github.com/repos/sapiens/SqlFu/issues/69/labels{/name}","comments_url":"https://api.github.com/repos/sapiens/SqlFu/issues/69/comments","events_url":"https://api.github.com/repos/sapiens/SqlFu/issues/69/events","html_url":"https://github.com/sapiens/SqlFu/issues/69","id":110951411,"number":69,"title":"Column Mapping","user":{"login":"mixerp","id":5273383,"avatar_url":"https://avatars.githubusercontent.com/u/5273383?v=3","gravatar_id":"","url":"https://api.github.com/users/mixerp","html_url":"https://github.com/mixerp","followers_url":"https://api.github.com/users/mixerp/followers","following_url":"https://api.github.com/users/mixerp/following{/other_user}","gists_url":"https://api.github.com/users/mixerp/gists{/gist_id}","starred_url":"https://api.github.com/users/mixerp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mixerp/subscriptions","organizations_url":"https://api.github.com/users/mixerp/orgs","repos_url":"https://api.github.com/users/mixerp/repos","events_url":"https://api.github.com/users/mixerp/events{/privacy}","received_events_url":"https://api.github.com/users/mixerp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-10-12T10:47:26Z","updated_at":"2015-10-12T17:01:07Z","closed_at":null,"body":"Kudos to SqlFu team. To me, this ORM is the most promising one. We are currently using PetaPoco which has become old and clumsy. I would really like to use SqlFu but stuck here.\r\n\r\n# How to map this\r\n\r\n```\r\nCREATE TABLE public.persons\r\n(\r\n    first_name    text,\r\n    last_name     text\r\n);\r\n```\r\n# to this\r\n```\r\npublic class Person\r\n{\r\n    public string FirstName { get; set; }\r\n    public string LastName { get ; set ; }\r\n}\r\n```\r\nIn our case, it is safe to assume that all database objects follow underscore convention. How can I use SqlFu? Any help will be warmly appreciated."},"comment":{"url":"https://api.github.com/repos/sapiens/SqlFu/issues/comments/147461177","html_url":"https://github.com/sapiens/SqlFu/issues/69#issuecomment-147461177","issue_url":"https://api.github.com/repos/sapiens/SqlFu/issues/69","id":147461177,"user":{"login":"sapiens","id":1608087,"avatar_url":"https://avatars.githubusercontent.com/u/1608087?v=3","gravatar_id":"","url":"https://api.github.com/users/sapiens","html_url":"https://github.com/sapiens","followers_url":"https://api.github.com/users/sapiens/followers","following_url":"https://api.github.com/users/sapiens/following{/other_user}","gists_url":"https://api.github.com/users/sapiens/gists{/gist_id}","starred_url":"https://api.github.com/users/sapiens/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sapiens/subscriptions","organizations_url":"https://api.github.com/users/sapiens/orgs","repos_url":"https://api.github.com/users/sapiens/repos","events_url":"https://api.github.com/users/sapiens/events{/privacy}","received_events_url":"https://api.github.com/users/sapiens/received_events","type":"User","site_admin":false},"created_at":"2015-10-12T17:01:07Z","updated_at":"2015-10-12T17:01:07Z","body":"Thanks for your kind words, however SqlFu is **not** and ORM, it's a _micro_-ORM (which is a very unfortunate name). Objects (POCOs) are just **sources** or **destinations** of data. There is no object to table mapping as it is with a real ORM.\r\n\r\nI recommend to use SqlFu as a data mapper with helpers, instead of using ado.net but **not** as an ORM.\r\n"}}