ant2boss / mssqlsimpleclient

A (hopefully) simple library for calling SQL procedures and parsing data from databases,

Hi there 👋

I am a clock.

mssqlsimpleclient's Issues

Implement direct client

Direct client will not procedures, but will instead work with generics, this is not a very safe way of doing things, so the goal is to create a "safe" way of doing things in order to maybe streamline the process...

• Object have to be configurable, create some attribtues to enable table definitions.
• Create
• Delete
• Get single
• Get all
• Some filtering would be nice, but I don't know how to do that

Just, please don't spend too much time on this... It's not too important

Implement DataSet grouping

Every object must define the IdentityAttribute on one of its memebers (it's not a must). If multiple objects with the same identity apear, we should either throw an exception or look to fillup a GroupedCollection

• GroupedCollection - Special collection for objects from database
• Integrate GroupedCollection with DataSet parser utility
• Ensure that GroupedCollection in GroupedCollection works
• Write some test to make sure this is working like it should (at least 3 test please)

Documentation for SqlClient

Create documentation (readme) for the SqlProcedureClient

• Getting started
• Usecases
• Groupings
• Different attributes
• Examples
• Pros & Cons

Implement DataSet to collection

When a query is executed a DataSet is reutrned.

Create a utility object to handel DataSet parsing into concrete objects.

• Data set converter object
• Data set -> Type conversion
• Extension method
• SqlColumnNameAttribute

Implement direct client extensions

• Connect the direct client with extension methods

Implement DataSet to single

Sometimes you don't really care about everything but you just want the one single record.

• Ensure all of the GroupedCollections groupings are still applied
• Write tests to ensure this is working (at least 2 please)

Implement Extension methods

All of these utilities are great. Now connect evertything togehter using extension methods to make everything fell more smooth (like jazz)

• SqlProcedureClient and DataSet conversions should be connected
• DataSet to collection should be connected
• DataSet to single should be connected