Hello,Is it possible to write a query where two fields are the same such as SELECT * FROM [TABLE] WHERE [Field1] = [Field2] I see we can call .WhereEquals(leftside, rightside) but how can I tell th...

How can I call a stored procedure in custom code that have a parameter type as User-Defined Table Type? I can't figure out how to assign the TypeName to the DataParameter item. I'm using V8.1.

I am trying to use the CMSConnectionContext with an external DB. I have my connection string setup properly in my web.config.Here's my code. I got this pretty much verbatim from support.using (var ...

Securing websites should be second nature to developers. Ever since the first sites launched, people have been trying to hack them using any means possible. With the proliferation of mobile technologies, machine learning, and nearly limitless computing power at hackers’ disposal, it’s more important than ever to ensure your sites are safe and not vulnerable. In this blog, I’ll cover how to lock down your site from one of the most widely known and utilized attacks: SQL Injection.

I was working with custom table API , and I read some blog posts of how to use DateQuery @ ObjectQuery, But I notice that there is no benifit to use these two classes over useing my own ORM or Tiny...

Hello,I am having a rather odd issue with the DataQuery api. I am using both Distinct(true) and OrderBy descending but it doesn't seem to like using them both together. If I take off the OrderBy an...

Hi,I'm struggling to work out if it's possible to write a query that joins a DocumentQuery to a DataQuery (Customtable), or join 2 CustomTables in a DataQuery.Can anyone tell me if this is possible...

I'm having trouble finding docs on a way to do a general data query in a macro expression.In other words, something like this:{% query = new DataQuery(); query.From(@CMS_User@).Column(@UserID@).Whe...

Hello,I am starting a project (running on Kentico 8.2.13) where we will be utilizing Custom Tables instead of Documents in the tree. We are creating a separate project to represent the abstractions...

As GeneralConnection.ExecuteNonQuery gets depricated I was wondering how to retrieve the number of affected rows when using DataQuery(@custom.insertquery@). The depricated code looks like this:retu...