New helpers, MD5, and some cleanup
- New
MD5
phrase, underdg.Sql.Phrases.Encoding
- Changed many function argument names to lowerCase for CLS compliance.
- Exposed Phrase private members for public usage
- Added a
CreateIndex
helper that accepts an index'es name - and looks for theIndex
object by itself - Old
Join
overloads which do not AcceptJoinColumnPair
s are marked asObsolete
- New Join overloads for
InnerJoin(...)
,LeftJoin(...)
,RightJoin(...)
etc. TableSchema.SchemaName
renamed toTableSchema.Name
. Old property still works.AbstractRecord.TableSchema
renamed toAbstractRecord.Schema
. Old property still works.- New
SchemaName
property inAbstractRecord
for convenience. Points at Schema.Name - New
ExecuteCollection(...)
helper inQuery
, to return anAbstractRecordList
of a type - New constructor overloads for common Phrases
- New
PhraseHelper
class with static constructors of common Phrases - Breaking change: In the VSIX DAL class generator, both
FetchByID
andDelete
functions are now generated with theconnection
argument at the end. This is to keep consistency with the way it works in other functions across the library, and to allow a default value of null.
Quick tip:
If you want to migrate all old Join syntaxes to the new one, you can use a replace like this:
"Replace in Files", "Entire Solution", mark the "Regular Expression" box.
Find: \.Join\(([^,]+),\s*([^,]+\.(?:TableSchema|Schema)),\s*([^,]+),\s*([^,]+\.SchemaName|"[^"]+"),\s*([^,]+\.(?:TableSchema|Schema)),\s*([^,]+),\s*([^,]+\.SchemaName|"[^"]+")\)
Replace With: .Join($1, $5, $7, new JoinColumnPair($2, $3, $6))