how to write a code for sql parser to parse select statements in c#.
muthu1802 -4
Newbie Poster
Recommended Answers
Jump to PostI pulled it off of another site hope it helps you...
using System.Data.EntityClient; ... EntityConnection conn = new EntityConnection(myContext.Connection.ConnectionString); conn.Open(); EntityCommand cmd = conn.CreateCommand(); cmd.CommandText = @"Select t.MyValue From MyEntities.MyTable As t"; var queryExpression = cmd.Expression; .... conn.Close();
All 2 Replies
jamesonh20 12
Junior Poster in Training
I pulled it off of another site hope it helps you...
using System.Data.EntityClient;
...
EntityConnection conn = new EntityConnection(myContext.Connection.ConnectionString);
conn.Open();
EntityCommand cmd = conn.CreateCommand();
cmd.CommandText = @"Select t.MyValue From MyEntities.MyTable As t";
var queryExpression = cmd.Expression;
....
conn.Close();
kvprajapati 1,826
Posting Genius Team Colleague
>how to write a code for sql parser to parse select statements in c#
You should use regular expressions. For your reference, visit codeProject article - http://www.codeproject.com/KB/dotnet/SQL_parser.aspx
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.