Looking for SQL Profiler API C#

Question

0.00/5 (No votes)

See more:

Hi everyone,
when i am researching SQl and C#, i saw this API:
https://technet.microsoft.com/en-us/library/ms345134%28v=sql.90%29.aspx[^]

It's said the new API can provide new method for programming with SQL-C#.
I read it. But it's not enough. I looked for example code but all about tool(sql profiler tool).
So please help me.
I just want to code example.
Thank in advance.

Posted 20-May-15 13:56pm

Tokisan

Add a Solution

Comments

barneyman 20-May-15 22:03pm

what are you trying to achieve? there's plenty of example code in there to create, replay and examine traces ..

Tokisan 21-May-15 5:02am

I am trying to used the new API for SQL tracer in my given link so that i know how to use. especially, how to select, insert, update and DELETE, i think i can insert update and select, but have no idea how to delete record. And how to use with "ODBC" connection in "ODBC" Aplication. I am doing my research. But it would be appreciated if someone help me. Thank in advance and sorry for my bad English.

Tokisan 21-May-15 5:03am

Please just show me a hint. Thank in advance.

barneyman 21-May-15 5:20am

oh - you just want to talk to a SQL database from C#?

that's EASY ...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

barneyman · Answer 1 · 2015-05-20T23:21:00

Solution 1

your comment above would suggest you're simply trying to use SQL from C# - you stumbled across a link that was talking about the profiler ...

this SQL/C# article[^] may help you

Posted 20-May-15 23:21pm

barneyman

Comments

Tokisan 22-May-15 0:46am

I knew how to connect to sql. What i am trying is using the API , provived by Micrpsoft with this link: "https://technet.microsoft.com/en-us/library/ms345134%28v=sql.90%29.aspx", and programming an ODBC aplication based on this API.
Microsoft said this API provide the new high-security method to talk to SQL.
I am looking for deeper materials and example.

Tokisan 22-May-15 0:47am

Sorry i am not good at English.

barneyman 22-May-15 1:02am

it's better than my Vietnamese ;)

The link you point to is *specifically* about using the SQL profiler, which is a performance and monitoring tool for SQL, that API provides no ability to access SQL data securely - i'm unsure what you're trying to achieve ..

Tokisan 22-May-15 1:22am

Yeah, tha's it. I want to implement SQL server profiler API into my "ODBC" Application. But don't have much examples on this. Anyway, thank for concerning me