T4Query.SqlServer provides developers with a single class to query SQL Server with the query. T4Query.SqlServer auto support Sql Transaction - If run query not fails: Commits the database transaction. - If run query fails: Rolls back a transaction from a pending state. T4Query.SqlServer always auto close the connection when done with the results returned (from below) T4Query.SqlServer support return result: - ExecuteNonQuery: return the number of rows affected. - SqlDataReader: return a System.Data.SqlClient.SqlDataReader object. - ExecuteXmlReader: return a System.Xml.XmlReader object. - ExecuteScalar<TSource>: return the first column of the first row in the result set, or a null if the result set is empty. Returns a maximum of 2033 characters. - DataTable: return a DataTable that contains elements. - DataSet: return a DataSet with select multiple table. - IEnumerable<TSource>: return an enumerator that can be used to iterate through the collection. - List<TSource>: A List that contains elements from the input sequence. - FirstOrDefault<TSource>: return default(TSource) if source is empty; otherwise, the first element in source. - Also, provide the SetDBNull (object) function: return DBNull.Value if object is null
FAQs
T4Query.SqlServer provides developers with a single class to query SQL Server with the query. T4Query.SqlServer auto support Sql Transaction - If run query not fails: Commits the database transaction. - If run query fails: Rolls back a transaction from a pending state. T4Query.SqlServer always auto close the connection when done with the results returned (from below) T4Query.SqlServer support return result: - ExecuteNonQuery: return the number of rows affected. - SqlDataReader: return a System.Data.SqlClient.SqlDataReader object. - ExecuteXmlReader: return a System.Xml.XmlReader object. - ExecuteScalar<TSource>: return the first column of the first row in the result set, or a null if the result set is empty. Returns a maximum of 2033 characters. - DataTable: return a DataTable that contains elements. - DataSet: return a DataSet with select multiple table. - IEnumerable<TSource>: return an enumerator that can be used to iterate through the collection. - List<TSource>: A List that contains elements from the input sequence. - FirstOrDefault<TSource>: return default(TSource) if source is empty; otherwise, the first element in source. - Also, provide the SetDBNull (object) function: return DBNull.Value if object is null
We found that t4query.sqlserver demonstrated a not healthy version release cadence and project activity because the last version was released a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Application Security
/Security News
Socket CEO Feross Aboukhadijeh and a16z partner Joel de la Garza discuss vibe coding, AI-driven software development, and how the rise of LLMs, despite their risks, still points toward a more secure and innovative future.
Research
/Security News
Threat actors hijacked Toptal’s GitHub org, publishing npm packages with malicious payloads that steal tokens and attempt to wipe victim systems.
Research
/Security News
Socket researchers investigate 4 malicious npm and PyPI packages with 56,000+ downloads that install surveillance malware.
