Hi, I am trying to use Blinq tool to create a website for AdventureWorks database to insert, update and delete records in any tables. As per instructions, I have downloaded May 2006 CPT and installed the utility. I see a virtual directory and website created;
but nothing more!
My assumption is Blinq tool creates a website (autogenerates web forms) to edit tables. Am I wrong or missed something?
Thanks in advance for your help.
Sam
blinq webforms auto-generate
-------------------------------------------------
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
Thanks for responding.. Yes the website was created with no errrors. I ran the command line utility. The default page opened up in IE.
I was able to open the project created and saw couple of classes under AppCode/ StaticMethods.cs .. this has a following partial class
public
static
MyClassName CreateDataContext() {
ConnectionUtil connectionUtil =
new ConnectionUtil();
ConnectionStringSettings connectionStringSettings =
WebConfigurationManager.ConnectionStrings["MyConnectionString"];
return new MyClassName(connectionUtil.CreateConnection(connectionStringSettings)); }
---- Then a Master page template is created, with Root listed in left margin..
---- Project compiles and shows me Default.aspx file (blank page with Master template)
Please let me know what I need to do to auto-generate web forms for all tables.
Thank you again.
Blinq LINQ auto-generate web forms
-------------------------------------------------
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
I am using AdventureWorks sample database, I believe each table has a PK. I didnot check each one of those. I remember not selecting some tables because they do not have PKs.
Thank you,
Sam
-------------------------------------------------
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
If your tables have fields and primary keys, I'm not sure why it's not working. AdventureWorks was one of the databases I did my testing against, so it's probably not the database.
Try running the tool again and see if you get an error message or something. I'm stumped...
Polita Paulus
This posting is provided "AS IS" with no warranties, and confers no rights.
Marked as answer by sdekha76 on Sep 29, 2007 01:02 AM
sdekha76
Member
308 Points
163 Posts
not able to view web forms
Sep 27, 2007 05:22 PM|LINK
Hi, I am trying to use Blinq tool to create a website for AdventureWorks database to insert, update and delete records in any tables. As per instructions, I have downloaded May 2006 CPT and installed the utility. I see a virtual directory and website created; but nothing more!
My assumption is Blinq tool creates a website (autogenerates web forms) to edit tables. Am I wrong or missed something?
Thanks in advance for your help.
Sam
blinq webforms auto-generate
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
sdekha76
Member
308 Points
163 Posts
Re: not able to view web forms
Sep 28, 2007 06:01 PM|LINK
Can anyone help me with my question?
All Gurus "answer... please!"
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
phuff
Contributor
2700 Points
547 Posts
Microsoft
Re: not able to view web forms
Sep 28, 2007 08:38 PM|LINK
Sam, can you send a few details? You say a website was created- were there webpages in the website? Did you see any error messages when Blinq ran?
This posting is provided "AS IS" with no warranties, and confers no rights.
sdekha76
Member
308 Points
163 Posts
Re: not able to view web forms
Sep 28, 2007 10:39 PM|LINK
Thanks for responding.. Yes the website was created with no errrors. I ran the command line utility. The default page opened up in IE.
I was able to open the project created and saw couple of classes under AppCode/ StaticMethods.cs .. this has a following partial classpublic
static MyClassName CreateDataContext() {ConnectionUtil connectionUtil =
new ConnectionUtil();ConnectionStringSettings connectionStringSettings = WebConfigurationManager.ConnectionStrings["MyConnectionString"];
return new MyClassName(connectionUtil.CreateConnection(connectionStringSettings)); }
---- Then a Master page template is created, with Root listed in left margin..
---- Project compiles and shows me Default.aspx file (blank page with Master template)
Please let me know what I need to do to auto-generate web forms for all tables.
Thank you again.
Blinq LINQ auto-generate web forms
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
phuff
Contributor
2700 Points
547 Posts
Microsoft
Re: not able to view web forms
Sep 28, 2007 11:54 PM|LINK
Sam, does your database have primary keys on each table? Blinq only creates pages for tables that have at least one primary key field.
This posting is provided "AS IS" with no warranties, and confers no rights.
sdekha76
Member
308 Points
163 Posts
Re: not able to view web forms
Sep 29, 2007 12:38 AM|LINK
I am using AdventureWorks sample database, I believe each table has a PK. I didnot check each one of those. I remember not selecting some tables because they do not have PKs.
Thank you,
Sam
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam
phuff
Contributor
2700 Points
547 Posts
Microsoft
Re: not able to view web forms
Sep 29, 2007 12:41 AM|LINK
If your tables have fields and primary keys, I'm not sure why it's not working. AdventureWorks was one of the databases I did my testing against, so it's probably not the database.
Try running the tool again and see if you get an error message or something. I'm stumped...
This posting is provided "AS IS" with no warranties, and confers no rights.
sdekha76
Member
308 Points
163 Posts
Re: not able to view web forms
Sep 29, 2007 01:05 AM|LINK
Hi Polita!
I created a sample DB with 2 tables, with PKs. I ran the tool again and now it works!
I will be implementing on DEV & later Integration database soon, hopefully things will go smoothly for Admin site.
Thanks again! Sam[Yes]
Click on "Mark As Answer" if this post gives you an idea to resolve the issue! Thanks, Sam